0

hi, dont usually ask for help since i believe in google. But im in a serious fix.

intro:
currently working on a table that has three fields, 'id' 'current' 'previous'.

problem:
i want to insert another field (or two - no too sure how to go about it) but with images (up_arrow and down_arrow). Now. When i create my query i would like it to automatically select a image depending on wether 'current' as improved or decreased (thus up_arrow, down_arrow).

Any help (or a push in the right direction) would be seriously appreciated. Thanks

2
Contributors
3
Replies
4
Views
10 Years
Discussion Span
Last Post by iamthwee
0

The best way to store graphics/images in a database is to not store it in the database. Confused? Of course. Instead of storing the file itself in the database just store the path to the image along with the image name. Store the image in some directory and when you need it just retrieve the filename and path to it.

0

thanks, but i already knew that, yes you can link the images or blob etc.... was hoping for information regarding the actaul query I'd have to use. Yet again, thanks for your somewhat, cocky reply.

0

I don't know what you mean. SQL is exactly that, basic structured query language. If you want to do anything more fancy with your data you have to use a language (such as php) to do stuff.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.