SQL (image) help

ohenewa

Hi guys,
I have created a database page where users can search for clothing and their prices. What I want to do now is to let images appear on the page as well.....do i have to put the iamge link or name in ma database? i'm using access....
any ideas please!!!!!!!!!!!

jalexf

The easiest way is to name your images the same as your unique product ID's. So the image for:

Ford F150 XLT model #25211

would be

25211.gif

and for a thumbnail I'll use

25211_t.gif

that way you don't have to store an extra image name in the DB, simply reference the image by the product ID#

ohenewa

so u mean to say, if for example my ID# is 22 for one of my records....i should name my image: 22.gif?
i don't really get this statement: "that way you don't have to store an extra image name in the DB, simply reference
the image by the product ID#"

can u elaborate further please........

jalexf

if for example my ID# is 22 for one of my records....i should name my image: 22.gif?

Correct! You will automatically know what the image name is because you know the product ID.

ID# 2365
image file would be: 2365.gif

That way you do not have to store extra information in your database. You do not need to add anything more to your table because the image name is simply the product ID.

If you need multiple sizes of an image, just add something on to the number.

ID# 2365
normal size gif: 2365.gif
thumbnail size: 2365_t.gif

That way you are keeping your naming convention yet can still have multiple sizes of the same image.

An offshoot of this---

I'll do a "check if this file exists" to see if 2365.gif exists on the disk. If it does not exist, change the file name to "nophoto.gif"

That way if you have an item that does not have an image, the GIF link won't be broken-- it will be a default "nophoto.gif"

Let me know if you get the first part before we start coding the second.