Getting info with WHILE
| From: | Ezequiel Sapoznik | Date: | Tue, 14 Jan 2003 03:09:10 +0000 |
| Subject: | Getting info with WHILE | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-131504@lists.php.net to get a copy of this message | ||
I have the following problem:
I have a DB named 'fotografias' with the following information:
ind indice_bio url
1 2 ../images/agosti.jpg
2 2 ../images/militar.jpg
3 2 hgfhgfh
4 2 eze
5 5 ezequi
ind, indice_bio and url are fields names.
I wrote the following code:
<?php
$dbase = mysql_connect("localhost", user , password);
mysql_select_db(historia,$dbase);
$respuesta = mysql_query("SELECT * FROM fotografias where indice_bio=$id",
$dbase);
$row1 = mysql_fetch_array($respuesta);
echo("<center>");
echo('<img border="0" src="../images/foto.wmf" width="62"
height="66">');
echo('<b>Hagá Click para ver las fotografías disponibles</b>');
echo("<br>");
echo("<br>");
while($row1 = mysql_fetch_array($respuesta))
printf("<tr><td> %s </td></tr>",
$row1["url"]);
echo("<br>");
}
mysql_free_result($respuesta);
mysql_close($dbase);
?>
The problem is that when I retrieve the info, for example with id=2, I only
get
../images/militar.jpg
hgfhgfh
eze
I do not get
../images/agosti.jpg
Any idea?
Thanks
Ezequiel
Ps. The page is located at http://www.historiadelpais.com.ar/bio.php?id=2