Creating a DB table

Junior WebHelper Joined: 20 Apr 2003 Posts: 1

if i wanted to create a db table with 3 gifs on it that were choosable and then when chosen have the gif displayed how would i do it..

i also would like it to be updatable so you can change the gif as and when...

sort of like these emoticons that go next to the thread you get one for each thread and you can change it ???

Team Member Joined: 06 Jan 2002 Posts: 2564

Do you want to store these GIFs in the database, or just store references to them?

images:
id,
url

WebHelper Joined: 01 Mar 2003 Posts: 69 Location: Texas

phill2003 wrote:

sort of like these emoticons that go next to the thread you get one for each thread and you can change it ???

Those aren't stored in the database, just the relative path and filename are. It's much better that way. The page is generated by dynamically setting the image path and filename, then the web server "serves" the image as requested. So to add a new image, you would a) upload the image, then b) insert a row in the database with that image location.

Dave