[PHP-DEV] PHP 4.0 Bug #7074: Contador no busca los demás registros From: leonela <email protected>
Date: 10/06/00

From: leonela <email protected>
Operating system: WIN32
PHP version: 4.0.3RC2
PHP Bug Type: MySQL related
Bug description: Contador no busca los demás registros

<?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> 

-- 
Edit Bug report at: http://bugs.php.net/?id=7074&edit=1

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>