Jump to content


Photo

Table of images


  • Please log in to reply
2 replies to this topic

#1 WormTongue

WormTongue
  • Members
  • PipPip
  • Member
  • 13 posts
  • LocationIllinois

Posted 03 July 2003 - 04:39 PM

I am trying to setup a mysql table that will only hold images. As a webpage is requested, the code will look in the mysql database and pic a random image. My question is 1) is this possible? and 2) how do i go about making my table to store the images and upload the images? Thanks for your help.
WHOHOO! I am now a Forum Regular!! :)

#2 JDawg

JDawg
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 03 July 2003 - 06:19 PM

I made a mysql table that held a location name, address, city, state, and a picture for that location. In my Image column in the table I just stored the pathname to the picture I wanted. Storing the actual photo in mysql is possible but it bloats the table.

I stored my pictures under images/location on my webhoster\'s server. So say for location #1 I would just store the pathname images/location/picture1.gif in the image column. Location #2 pathname = images/location/picture2.gif and so forth.

Hope this helps.

JDawg

#3 WormTongue

WormTongue
  • Members
  • PipPip
  • Member
  • 13 posts
  • LocationIllinois

Posted 03 July 2003 - 06:37 PM

Thanks for the reply. That really helps out a lot.
WHOHOO! I am now a Forum Regular!! :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users