Images and database

[aepstar]

Hi folks!

I searched the forums quiet good, but was unable to find something of a use.

Here's my problem.

Many images are stored into different folders, because storing them as a blob slows the database tremendously. In my folders part of the filesnames are the same. Now I want to put description of each image into the database. So the table becomes:

id - path - filename - description

so when i let people se images via a link on the frontpage, the images will be retrieved from the 'path' dir. the filenames are easily to loop through - they are 1.gif 2.gif etcetera.

However, i have this problem now.

suppose i delete 55.gif. i have now 1.gif till 100.gif without 55.gif. in order to display all the images - which are looped through - i would want to rename them like 1.gif till 99.gif. the question is, can i make a script that will rename them and store the new filenames in the table WITHOUT messing up the description of an image? How than?

Are there any other ways for my problem?

thanks!

[AstroTeg]

So you do have image info stored in the DB, right? If so, when you delete an image, just delete the record from the DB. Use the DB to query for which images you have available. Thats just one way to do it.

You could also check if the file exists. But this would probably slow down your script a little bit since it has to test if all those images exist. But if the image doesn't exist, it just skips it...

[aepstar]

yes to query images via database is ofcource one thing. you could loop through the records, since there are ni skips if u delete one image.

thank you.

but imagine i have image 55.gif with description "uggly". how can i rename this image to 54.gif, yet that the description stays "uggly" ?