Problem query all DB !!!!!!!!!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
maceved23
Forum Newbie
Posts: 17
Joined: Sun Jul 13, 2003 11:56 pm

Problem query all DB !!!!!!!!!

Post by maceved23 »

Hi I'm having a problem doing a query to my DB.

Here's the code I use to query, the problem is I only get the info, of only one user.

AND MY BIG PROBLEM IS I NEED TO QUERY FOR MORE THAN ONE VARIABLE IN MY DAB AND TO RECIEVE THE QUERY RESULT,
NEED HELP!!!!

*************************************************************
HTML CODE TO TYPE THE EMAIL I QUERY
*************************************************************
echo " <h4><P>TYPE THE EMAIL.</P></h4>";
echo "<FORM ACTION='conf_mail.php' METHOD='GET' NAME='busca_mail'>";
echo "<TABLE CELLSPACING='0' CELLPADDING='0' BORDER='0' WIDTH='375' BGCOLOR='#99B9D0'>";
echo " <TBODY>";
echo " <TR> ";
echo " <TD><IMG SRC='cp-bcorn.gif' WIDTH='13' HEIGHT='12'></TD>";
echo " <TD WIDTH='100%'></TD>";
echo " <TD ALIGN='right'><IMG SRC='cp-bcorn2.gif' WIDTH='13' HEIGHT='12'></TD>";
echo " </TR>";
echo " <TR> ";
echo " <TD COLSPAN='3' ALIGN='CENTER'><TABLE WIDTH='100%' CELLPADDING='2' CELLSPACING='1'>";

echo " <TR> ";
echo " <TD VALIGN='MIDDLE' ALIGN='RIGHT' WIDTH='75'><P>Email*:</P></TD>";
echo " <TD VALIGN='MIDDLE' ALIGN='LEFT'> <INPUT TYPE='TEXT' NAME='email_busca' SIZE='45' MAXLENGTH='60'></TD>";
echo " </TR>";
echo " </TR>";
echo " </TABLE>";

echo " <INPUT name='SUBMIT' TYPE='SUBMIT' CLASS='button' VALUE='ENVIAR'>";
echo " &nbsp;";
echo " </TD>";
echo " </TR>";
echo " <TR>";
echo " <TD><IMG SRC='cp-bcorn3.gif' WIDTH='13' HEIGHT='12'></TD>";
echo " <TD ALIGN='right'><IMG SRC='cp-bcorn4.gif' WIDTH='13' HEIGHT='12'></TD>";
echo " </TR>";
echo " </TBODY>";
echo "</TABLE>";
echo " </FORM>";


*************************************************************
PHP CODE OF THE QUERY
*************************************************************

<?php
include('config.php');


db_connect();
viewheader();

$res = mysql_query("SELECT * FROM `$dbtable` WHERE `email1` = '{$_GET['email_busca']}' LIMIT 10") or die(mysql_error());


if (mysql_num_rows($res)<1){

echo"<br>";
echo"<br>";
echo"<br>";
echo "THIS EMAIL IS NOT IN DB!!!!";
echo"<br>";
echo"<h4><a href=\"javascript:history.back()\">Regresar</a></h4>";
} else {
$row = mysql_fetch_assoc($res);

echo"<br>";
echo"<br>";

echo"<h4>USER INFORMATION</h4>";
echo"<br>";
echo"<td valign='top'><font><b>{$row['nombre']} {$row['apellido1']} {$row['apellido2']}</b><br>";
echo"<br>";
echo"<td valign='top'><a href='mailto:{$row['email1']}'>{$row['email1']}</a></td><br>";
echo"<br>";
//echo"<a href='fiche_membre.php?id=$myid'</a>";
echo"<a href='fiche_membre1.php?id={$row['id']}' target='_blank') onMouseOver=\"status='Consultar Información del usuario'; return true;\" onMouseOut=\"status='';\">Consultar Información del usuario</a><br>";
hits</font></td>";
</font></center></td>";
echo"<br>";
echo"SEND EMAIL";
echo"<td><a href='envio_mail.php?id={$row['id']}' target='_blank' onMouseOver=\"status='Ingresar'; return true;\" onMouseOut=\"status='';\"><center><img src='checkbox.gif' width='18' height='18' border='0'><b></b></center></a></td><br>";

}
?>

----------------------------------------END----------------------------------------

WITH THIS CODE I ONLY GET ONE USER INFO, AND IN MY DB I HAVE TWO USERS WITH THE SAME MAIL. I KNOW THE EMAIL IS NOT GOING TO BE THE SAME NEVER, BUT THIS IS A TEST 'CAUSE I NEED TO QUERY THE DB SEARCHING FOR USER NAME FOR EXAMPLE.

THANKS
MARIO
User avatar
irealms
Forum Contributor
Posts: 215
Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds

Post by irealms »

instead of :

Code: Select all

<?php
row = mysql_fetch_assoc($res); 

?>
you want to use a while loop, while loops will call out each row matching the query until it reaches the last row

such us :

Code: Select all

<?php
while ($row = mysql_fetch_assoc($res))
{
//then what you want to show for each row
}

?>
this will show a row for each match of the query
Post Reply