Bug #7075 Updated: Contador no busca los demás registros

ID: 7075 Updated by: sniper Reported By: leonela@portalambato.com Old-Status: Duplicate Status: Bogus Bug Type: MySQL related PHP Version: 4.0.3RC2 Assigned To: Comments: Previous Comments: --------------------------------------------------------------------------- [2000-10-06 19:02:55] leonela@portalambato.com Disculpe-- la versión que utilizo es PHP· <?php for ($n=0; $n<=10; $n++){ } $result = mysql_query("SELECT * FROM Empresa where Actividad ='$Actividad' && Revisar ='1' ORDER BY Empresa LIMIT $n"); if ($row = mysql_fetch_array($result,$n)){ echo "<td><p align='center'>Se han encontrado $n registros relacionados con $Actividad...!</p></td>"; do { echo ("<B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Razón Social</B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;<TD>$row->Empresa</TD>n"); echo("<br>"); echo ("<B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dirección</B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;<TD>$row->Direccion</TD>n"); echo("<br>"); echo ("<B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Teléfono</B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;<TD>$row->Telefono</TD>n"); echo("<br>"); echo ("<B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Email</B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;<TD><A href=mailto:$row->Email>$row->Email</A></TD>n"); echo("<br>"); echo ("<B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Página Web</B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;<TD><A href=http://$row->Pagina>$row->Pagina</A></TD>n"); echo("<br>"); echo("<B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Actividad</B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;<TD>$row->Actividad</TD>n"); echo("<br>"); echo ("<B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ciudad</B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;<TD> $row->Ciudad</TD>n"); echo("<hr>"); }//do while ($row = mysql_fetch_array($result,$n)); }//if while ( list($row_number, $row_array) = each($query_result_array){ echo("<A HREF=buscar.php3?Actividad=$Actividad>Próximos 10</a></p></td>"); } ?> <html> <div align="center"><center> <table border="0" cellpadding="0" cellspacing="0"> <tr> <td><a href = "idatos.htm">Ingresa tu empresa a nuestro directorio<a></td> <td width="100"><p align="center"> <a href="index.html" target="_top"><img src="Graficos_aps/portal.gif" border="0" width="26" height="30"></a></td> <td><a href = "tuempresa.html">Haz click aquí para modificar tus datos</a></td> </tr> <tr> <td></td> <td width="100"><small><p align="center"></small> <small>Principal</small></td> <td></td> </tr> </table> </center></div> </html> --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=7075&edit=2