[SOLVED] Why does php returning only one row of data?

[pneudralics]

Can't figure why php is only returning one row of data.

 

//Website url
$websiteurl = WEBSITEURL;
//Retrieve gallery info
$galleryselect = "SELECT * FROM gallery ORDER BY id ASC";

if ($galleryresult = mysql_query ($galleryselect)) {
while ($row = mysql_fetch_array ($galleryresult)) {
$gallery = $row['image'];
}
}
?>

<table width="800" align="center">
    <tr>
        <td width="100%" align="center">
<?php
echo '<img src="'.$websiteurl.'/images/gallery/'.$gallery.'">';
?>         
        </td>
</tr>
</table>

[wildteen88]

Your HTML code needs to be within your while loop otherwise only the last result will be displayed.

<table width="800" align="center">
    <tr>
        <td width="100%" align="center">
<?php

//Website url
$websiteurl = WEBSITEURL;
//Retrieve gallery info
$galleryselect = "SELECT * FROM gallery ORDER BY id ASC";

if ($galleryresult = mysql_query ($galleryselect))
{
    while ($row = mysql_fetch_array ($galleryresult))
    {
        $gallery = $row['image'];

        echo '<img src="'.$websiteurl.'/images/gallery/'.$gallery.'" />';
    }
}
?>
        </td>
   </tr>
</table>

[pneudralics]

TG

Your HTML code needs to be within your while loop otherwise only the last result will be displayed.

<table width="800" align="center">
    <tr>
        <td width="100%" align="center">
<?php

//Website url
$websiteurl = WEBSITEURL;
//Retrieve gallery info
$galleryselect = "SELECT * FROM gallery ORDER BY id ASC";

if ($galleryresult = mysql_query ($galleryselect))
{
    while ($row = mysql_fetch_array ($galleryresult))
    {
        $gallery = $row['image'];

        echo '<img src="'.$websiteurl.'/images/gallery/'.$gallery.'" />';
    }
}
?>
        </td>
   </tr>
</table>

 

THanks.