What would be an SQL statement if I wanted to import lots of images into a MySQL db table at once?
A PHP solution would suffice as well.
Thank you.
Piotr.
Forget all about putting images in a database, it serves absolutely no purpose and only slows you down.
OK - Let's say I have over 1GB of images, mainly JPEG, and I want to put description on each individual image, its location (where the picture was taken), and its date.
What type of organization do you suggest for maintaning this?
Thanks,
Just one table that contains the image filename, date and all other relevant information about the image, like categories etc.
Then build a simple interface that lists all the image-titles etc so users can select an image to view.