Craig Oettle wrote:
> I'm sure I'm missing something simple but would some one mind telling
> how to insert a gif file into a table instead of just the name of the
> file. I have a table like this:
> create table producta(
> itemno varchar(40) not null,
> descript varchar(100),
> price decimal(8,2),
> pic blob
> What I try:
> insert into producta values(
> 'blah blah blah',
> Any help would be appreciated.
> Craig Oettle
You need to store it in a BLOB and properly escape it.
The way you are doing it now would be better in my opinion, except you
will need to create a directory tree for your images so you will not
have everything in one directory.