!!!!!! ROW Table PROBLEM !!!!!!!
Posted: Wed Sep 03, 2003 4:01 am
Hi.
I'm having a problem with a page I want to show. My query is working perfect but when a I get data from my DB, a table is create for each user.
I need to show data of each user one after one in my table, one row for each user.
This is the code
HELP ME I KNOW IT COUL BE SIMPLE BUT I DON'T SEE THE ERROR
I'm having a problem with a page I want to show. My query is working perfect but when a I get data from my DB, a table is create for each user.
I need to show data of each user one after one in my table, one row for each user.
This is the code
Code: Select all
include('config.php');
if (empty($email_busca))
{
viewheader();
echo"<h4>Olvido digitar el correo electrónico que desea consultar</h4>";
echo"<br>";
echo"<center><h4><a href="javascript:history.back()">Regresar</a></h4></center>";
viewfooter();
exit;
}
db_connect();
viewheader();
$res = mysql_query("SELECT * FROM `$dbtable` WHERE `email1` LIKE '%{$_GET['email_busca']}%' LIMIT 10") or die(mysql_error());
if (mysql_num_rows($res)<1){
echo"<br>";
echo"<br>";
echo"<br>";
echo "ESTE CORREO ELECTRÓNICO NO HA SIDO REGISTRADO!!!!";
echo"<br>";
echo"<h4><a href="javascript:history.back()">Regresar</a></h4>";
} else {
while ($row = mysql_fetch_assoc($res))
{
echo"<br>";
echo"<h4>ESTOS SON LOS DATOS DEL USUARIO CONSULTADO</h4>";
echo"<br>";
echo"<table width='80%' border='0' cellpadding='1' cellspacing='0' class='textfield2'>";
echo"<tr bgcolor='#F6F6F6'>";
echo"<td valign='top' align='right' colspan='4'>";
echo"<font>";
echo" - ";
echo"<a href='menu.php'>REGRESAR</a>";
echo" - ";
echo" - ";
echo"<a href='logout.php'>SALIR</a>";
echo" - ";
echo"</font>";
echo"</td>";
echo"</tr>";
echo"<tr>";
echo"<td valign='top'>";
echo"<table width='100%' border='0' cellspacing='1' cellpadding='3' align='center'>";
echo"<tr bgcolor='#F1F1F1'>";
echo"<td valign='top' colspan='3'>";
echo"<font>";
echo"<tr bgcolor='#F6F6F6'>";
echo"<td><font><b>Nombre</b></font></td>";
echo"<td><font><b>Email</b></font></td>";
echo"<td><font><b>Consultar</b></font></td>";
echo"<td align='center'><font><b>Mail</b></font></td>";
echo"<td align='center'><font><b>Seguimiento</b></font></td>";
echo"</tr>";
echo "<tr bgcolor='$bgColor'>";
echo"<td valign='top'><font><b>{$row['nombre']} {$row['apellido1']} {$row['apellido2']}</b><br>";
echo"<td valign='top'><a href='mailto:$email1'>{$row['email1']}</a></td>";
echo"<td><a href='fiche_membre1.php?id={$row['id']}' target='_blank') onMouseOver="status='Consultar Información del usuario'; return true;" onMouseOut="status='';">Consultar Información</a><br></td>";
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>";
echo"<td><a href='seguimiento.php?id={$row['id']}' target='_blank' onMouseOver="status='Ingresar'; return true;" onMouseOut="status='';"><center><img src='seg.gif' width='22' height='18' border='0'><b></b></center></a></td><br>";
echo"<tr bgcolor='#F6F6F6'>";
echo"<td valign='top' align='right' colspan='5'>";
echo"<font>";
echo" - ";
echo"<a href='menu.php'>REGRESAR</a>";
echo" - ";
echo" - ";
echo"<a href='logout.php'>SALIR</a>";
echo" - ";
echo"</font>";
echo"</td>";
echo"</tr>";
echo"</table>";
echo"</td></tr></table>";
echo"<br>";
echo"<br>";
}
}