MySQL and images

How do I insert images into tables?

[cyclic]

I have a database of products and wish to insert images into the database. Do I place them in a separate directory to be pulled from the database?

[jatar_k]

I have always stored the relative path and then put the images within their own directory or section of the tree.

How many different directories you use will have to do with the number of images you plan on having. Scalability becomes important when you set this up.

[cyclic]

Thanks - but what is scalability?

[jatar_k]

Scalability

How well a solution to some problem will work when the size of the problem increases.

Make sure if you go from 10 img's to 1000 img's your solution is still valid

[cyclic]

Thank you - must be a cross Atlantic word!! At the moment I have only 30 images to go with the database. If it is not obvious, this is all fairly new to me! From each image I wish to link to a new page ie. from thumbnail to larger image and details.

[jatar_k]

shouldn't be too bad then.

You know where to find us for questions or mysql.com is where I always go.