Need help with unique array output

[pfhowe]

Any help will be much appreciated with this - it's driving me nuts!

I have the following query which outputs an array which is then read by javascript to show the last 20 images uploaded in a slideshow.

$query = "SELECT `imageid` FROM `gallery` WHERE `section_code` = '$section' AND `category_code` = '$category' AND `imageid` != '' ORDER BY `date` DESC LIMIT 20 ";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$count = mysql_num_rows($result);
for ($i = 0; $i < $count; $i++)
{
echo "fadeimages[".$i."]=[\"http://www.mysite.co.uk/images/photo_gallery/thumbs/".$row['imageid']."\", \"\", \"\"]\n";

It outputs this...

fadeimages[0]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[1]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[2]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[3]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[4]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[5]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[6]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[7]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[8]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[9]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[10]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[11]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[12]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[13]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[14]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[15]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[16]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[17]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[18]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]
fadeimages[19]=["http://www.mysite.co.uk/images/photo_gallery/thumbs/1240504679ccup4.jpg", "", ""]

The problem is that all the "imageid"'s are the same. How do I get this to return the last 20 images instead of just one 20 times?

[mooger35]

Try this instead:

$query = "SELECT `imageid` FROM `gallery` WHERE `section_code` = '$section' AND `category_code` = '$category' AND `imageid` != '' ORDER BY `date` DESC LIMIT 20 ";
$result = mysql_query($query) or die(mysql_error());

$count = mysql_num_rows($result);

if($count > 0){
$i=0;
while($row = mysql_fetch_assoc($result)){
echo "fadeimages[".$i."]=[\"http://www.mysite.co.uk/images/photo_gallery/thumbs/".$row['imageid']."\", \"\", \"\"]\n";
$i++;
}
}

[pfhowe]

Mooger35

That worked like a dream. Thanks very, very much!