Why don't you use mysql_fetch_assoc() instead? You can address your fields
directly, as in:
while($row_FOTOS=mysql_fetch_assoc($result))
{
echo "<img src='products/".$row ["picture1"]."' border='0'
height='384' />";
echo "<img src='products/".$row ["picture2"]."' border='0'
height='384' />";
}
Alternatively, you can specify which fields you want in your SQL statement:
$sql = "SELECT picture1, picture2 FROM picture WHERE id = '$ID'";
$result =mysql_query($sql,$conn);
while($row_FOTOS=mysql_fetch_array($result))
{
echo "<img src='products/$row [0]' border='0' height='384' />";
// picture1
echo "<img src='products/$row [1]' border='0' height='384' />";
// picture2
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
