[PHP] Getting info with WHILE

[Ezequiel Sapoznik]

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>&nbsp;%s&nbsp;</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





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php