Bob Crandell wrote:
> I'm using Apache/PHP/MySQL to learn SQL. Besides dazzling
> people with my prowess, I'd like to be able to store digital
> pictures in the database. So far, I've gotten to the chapter
> that creates a form to type in a product code, description and
> price. Yawn.
> Does anyone know the SQL code to insert a binary file into a
> MySQL database? What type of field does it take? I didn't see
> mention of a blob. Maybe that's the next book.
I don't want to discourage you from learning SQL. (I'm trying
to do the same myself.) But...
Check out Photoshelf. It's a photo indexing application based on
Apache, Perl, and PostgreSQL. I've set it up and indexed several
hundred of our photos.
http://photoshelf.sourceforge.net/
It's still rough, mostly because configuring Apache and PostgreSQL
is rough. But it's worth checking out.
There's a public demo here.
http://www.cactii.net/perl/index.cgi/
Log in as guest, password is guest.
--
Bob Miller K<bob>
kbobsoft consulting
http://kbobsoft.com [EMAIL PROTECTED]