PHP Looping script

Hello all
I'm new here and I need some advice. Im trying to create a script that will loop and return multiple variables.
for example I have a mysql database with image records in it. I want the script to return something like

$image1="image1name"
$image2="image2name"

but the amount of images in the database changes all the time so one day i may have 10 and the next day 25

I hope this makes sensei
Thanks in advance
Pete

Check out arrays. From what it sounds like, those will make your life a lot easier.

http://php.net/array

It would help if you gave a description of the table including a row or two of sample contents, and how it was populated.

I've never really done this, but here's an interesting idea at least, assuming 1) a table whose first field is the autonumber and 2) the second field is a graphic that you want identified with the autonumber:

Code: Select all

while($row = mysql_fetch_row($result)) {
    $no = $row[0];
    $a=image;
    ${$a . $no} = $row[1];
}

I don't have time to play with it, but this (or something along this line) might work, and would give $image1=(image in first row), $image2=(image in second row).

Just a thought. If I'm missing something really stupid, I'm sure someone will point it out

Hi there

You can fairly easily create $image1 to $image100 etc., using variable variables, however given the number is going to shift ongoing it would be better to learn to use arrays and store the images in an array instead:
$images = array(); $counter = 0;
while ($r = mysql_fetch_row($result)) {
//you could say
$images[$counter] = $r[0]; // or wherever in the result set the image is
//or perhaps
array_push($images, $r[0]);
//also several other ways; if you really want to assign to strings
${"image$counter"} = $r[0];
//look up variable variables for more info on php.net
$counter++;
}
//this is what your array now has:
print_r($images);