store image location in mysql

[generic]

Hi all,

I'm looking for a solid way to store an image location in mysql. I've been throwing different ideas around all day and nothing is striking me. I'd like to be able to view the image again later so saving the full path is troublesome and I definitely don't want to save the full url - better if it's all in variables for when I switch servers.

What are some good ways (or a standard way?) to do this? Hope this makes some sense.

[toxic_brain]

better to store as relative path to ur home page

[generic]

Hmm... I'm just not having any luck. This is really one of my first adventures in mysql and I'm just not sure how exactly to go about saving the path so I can view the image from any page... there's probably some simple answer, I just don't know?