Hi there I have the follwoing code that runs a query on my database
The problem I am having is that $row returns more than one row/record from the database but the code only prints the first record. What I am trying to do is to print all records that was returned to $row
Code:
while ( $row = mysql_fetch_array($images) ) {
echo '<image>';
echo'<Name>'.$row['Name'].'</Name>';
echo'<Caption>'.$row['Caption'].'</Caption>';
echo'<URL>'.$row['URL'].'</URL>';
echo'<Supplier>'.$row['Supplier'].'</Supplier>';
echo'<Width>'.$row['Width'].'</Width>';
echo'<Height>'.$row['Height'].'</Height>';
echo'<ByteSize>'.$row['ByteSize'].'</ByteSize>';
echo'<ThumbnailURL>'.$row['ThumbnailURL'].'</ThumbnailURL>';
echo '</image>';
}
The problem I am having is that $row returns more than one row/record from the database but the code only prints the first record. What I am trying to do is to print all records that was returned to $row