Posted by Jeff on 01/27/07 02:45

"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:op.tmseqrmtqnv3q9@misant.kabel.utwente.nl...
Jeff <it_consultant1@hotmail.com.NOSPAM> wrote:

> Hey
>
> This php (version 5.20) code:
> $sql = "insert into Picture(Property, Mime, Data) values (1 , $type,
> \"".$image."\")";
>
> Generate this sql (MySql5) error:
> Unknown column 'image' in 'field list'
>
> Any suggestions on how to solve this are very welcome!

Euhm, echo $sql if you please...
--
Rik Wasmus

Here is the echo of $sql:
insert into Picture(Property, Mime, Data) values (1 , image/pjpeg,
"????\0JFIF\0
\0\0d\0d\0\0??\0Ducky\0
\0\0\0\0F\0\0??\0Adobe\0d?\0\0\0
??\0?\0
  P???")Unknown column 'image' in 'field list'

From $sql above I removed many characthers... it was very very many special
characters like  wich I removed in this post to make it more readable

Any suggestions?

Jeff

[Back to original message]