Multiple Images & MySql

I'm new to Mysql/Databases and am trying to figure out the best way to integrate a large number of images into a database, but need some help.

Basically what I have is an article/page with text and a number of thumbnail images to go with it. But the actual number of thumbnails in each article will vary quite considerably, from 0 - 30 conceivably.

I'm not uploading the images to the database, just the image name.

What is the best way to set this up in MySql. A separate table with a new row for each image?

Thanks in advance.

I just set up a photo archive db that stores the following info in a table:

1. file name
2. title (or description)
3. key words (for searching purposes)
4. source (photographer's name)
5. date

--The file name is unique.
--I do searches on all info.

I hope that provides some food for thought.

If you only want each filename/thumbnail to be linked to one story, then the solution is to do as you say. Create a table with one filename on each row and include a field that points to the ID of the story. You can then select all the filenames pointing to the particular story you're interested in, whether there be zero or 1000 of them.

If a filename can be linked to more than one story then that's a different matter! I can't think of an elegant solution for this. If you work it out let me know as it's similar to a problem I'm trying to solve.

Thanks for the advice, each image is linked to only one story so it looks like your solution will work Adrian2.