By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,722 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,722 IT Pros & Developers. It's quick & easy.

PHP mySQL - table of images

P: n/a
gsb
Not sure is best place to ask, but...
What should the mySQL table look like to save and extract a series of
images.
I want to "insert" an image by name (string) and later "select" and send it
to a web page.

Thanks,

gsb
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
the table should be reasonably simple, just 3 columns:

image_id (auto incrementing integer)
image_name (string of pre-determined length)
image_url (absolute or referential, either way this would be a
string... be sure to give it plenty of room though!)

That should be all you need... if you are finding yourself needing yet
more information at a later date, columns are easily added to existing
records. this method should allow you to retrieve the image url by
referring either the image_id or the image_name

Jul 17 '05 #2

P: n/a
I noticed that Message-ID:
<10**********************@z14g2000cwz.googlegroups .com> from
ad**@adamcoppin.com contained the following:
image_id (auto incrementing integer)
image_name (string of pre-determined length)
image_url (absolute or referential, either way this would be a
string... be sure to give it plenty of room though!)

That should be all you need... if you are finding yourself needing yet
more information at a later date, columns are easily added to existing
records. this method should allow you to retrieve the image url by
referring either the image_id or the image_name


Short description (useful to automatically add the alt="" attribute) and
long description are useful too.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.