Pictures and MySQL

I want to store pictures in a MySQL database, how would I go about inserting a picture into a MySQL database? Thanks

I upload the pictures I want to store to a webserver, and input the url of the image into the mysql database. If there's a way to just upload the image to the database, I'd like to know how to do this too.

I know with access databases you can store pictures directly in the database as type BLOB....so I am guessing you should be able to do it with MySQL...I guess we will just wait for someone to help us.

Well, PHP makes it very simple. The only problem is that the example I found only did one picture - a bit of a pain if you have several hundred to do :-) have a look at http://www.weberdev.com/get_example.php3?count=167

I also found an example which used Perl and DBI, but I can't get it to work. I think there is a fundamental error in the script I found and I can't fix it :-( So, I will try and write a bulk loader in PHP and post it ..

There's also an article in phpbuilder about this too..

<A HREF="http://www.phpbuilder.com/columns/florian19991014.php3" TARGET=_blank>http://www.phpbuilder.com/columns/florian19991014.php3
</A>

scoobydoo

[This message has been edited by scoobydoo (edited June 10, 2000).]