PHP mySQL - table of images

[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

[adam]

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

[Geoff Berrow]

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/