Images In Mysql

[artisticre]

I am a newbie and need help. I have searched all over the internet for an example and I don't understand most of them.

Here is my table

CREATE TABLE Producer (
producerid int(4) NOT NULL auto_increment,
producer varchar(100) NOT NULL default '',
producerdesc longtext NOT NULL,
picture_name varchar(25) NOT NULL default '',
PRIMARY KEY (producerid)
) TYPE=MyISAM;

Can someone show me the code to insert the image path into picture_name and the image into the directory and then the code to view the image with a select statement.

thanks for your help in advance

[rtown]

are you putting the images in the db or are they being uploaded by users?

[artisticre]

I am putting the images in the db

[stolzyboy]

you have already made a thread about this, you should keep going with the thread you were on so people can help you

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10228609