Get names of images from disk

[kbc1]

Hi all,

I have a table with X number of questions. Each question may have an image assocaited to it or it may not.

Within each question record in my table I have amongst other fields a field called imagename and a field called reference.

Now, if the set of questions has images associated to it, I will have the images in a folder on the server and the folder will be called the same as the reference as mentioned above (e.g. imagefolder1)

What I am looking for is a way or explanation on how to create a script that would loop though my table checking to see if

a) There is a reference in the table and on disk that match
and if so
b) store the image names from the files on disk to the associated imagename fields withint the records.

The names of the files are 1-5.gif. Each record in my table has a question number 1, 2, 3, 4, 5 etc to which image 1-5.gif will need to be saved into their imagename fields

I know this is a total long shot but I am sure some pro's out there have an idea of what it is I can do...

Thanks in advance.
K

[leatherback]

Not sure but.. Assuming you know how to query a database, then you could for each record take the table reference, glue it to 1-5.gif and test whether a file exists:

...
while($row=mysql_fetch_array($query))
  {
  for($i = 0; $,6; $i++)
    {
    $filename = $FILEPATH . $row['REFERENCE'] . $i . ".gif";
    if(is_file($filename))
      {
       // the file exists
      }
    }
  }