[alabaster_lynch]

Here is my problem.
1st, I have set up a server on my pc just for development purposes whenever I use the following script, It just shows the first row and nothing else. There are 69 records on that table. I know that it is not my query because it runs in phpMyAdmin.

Code:

$query = "SELECT images FROM gallery_images order by date desc";
$result = mysql_query($query);
$imageArray = mysql_fetch_array($result);

$numberOfImages = mysql_num_rows($result);
echo $numberOfImages;
for($i = 0; $i < $numberOfImages; $i++)
{
	echo $imageArray[$i].'<br>';
}

Please help me

thank you for your time....Jose

[shroder]

Just doing a mysql_fetch_array($result) will pull the first row. 'fetch_array' refers to putting the differnt fields into an array format. What your looking for is:

Code:

while($imageArray = mysql_fetch_row($result) {
    echo $imageArray[0].'<br/>';
}

mysql_fetch_row will allow you to just pick the variable by number instead of the field name. Since this is just one field we are selecting I figured it would be more simple to just pick by number.

[alabaster_lynch]

I knew I was too tired to be working right now...thank you for your help..

Jose

[shroder]

No problem.

Just remember to keep an emergency supply of coffee by your side at all times. You never know when fatigue will sneek up on you.