WormTongue Posted July 3, 2003 Share Posted July 3, 2003 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. Quote Link to comment Share on other sites More sharing options...
JDawg Posted July 3, 2003 Share Posted July 3, 2003 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 Quote Link to comment Share on other sites More sharing options...
WormTongue Posted July 3, 2003 Author Share Posted July 3, 2003 Thanks for the reply. That really helps out a lot. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.