Results 1 to 2 of 2
Thread: Database Driven website
Jul 11, 2000, 11:22 #1raghu_sitepointSitePoint Community Guest
I have been planning to develop a website that would allow users to enter their data and pictures. I would like to save each user in a row. But i have no idea of how to store the pictures, will i store them as files somewhere and then have a id pointing to these files in the database.
In the PHP/MYSQl series looks like kevin is storing the jokes itself in a column in jokes table. What if i had huge files that cant fit in a column.
I am not very good at db so .....
Thanks in advance
Jul 11, 2000, 11:31 #2
- Join Date
- Aug 1999
- Lancaster, Ca. USA
- 0 Post(s)
- 0 Thread(s)
Store the URL to the picture in your column. i.e. ROW 1 = http://www.yourdomain.com/pictures/userid/picture1.gif
Then in your code that builds the page you would write code that inserts that URL into an image tag via a variable.
Wayne Luke - Sitepoint Forums Administrator
Digital Magician Magazine - MetaQuark Creations (Coming Soon)