Problem query all DB !!!!!!!!!
Posted: Sun Aug 17, 2003 1:42 pm
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 " ";
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
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 " ";
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