Best way to handle dynamic images?

[yamangman]

So i have an access database (simply put) and I want an image for each record for dynamic content on a web page. What is the best way to handle this? Presumably have a cell in each record dedicated to the relative location of the image i.e. '../images/dynamic/thisimage.jpg'?

Or am I wrong or is there a better way?

Cheers

[directhex]

no, that's the best way, you don't want to store the images inside the databse itself (it's inefficient). you can write some scripts to automatically generate the filename, and tie that into the database

[Stoo]

yup, storing the filename/path is by far the best method