Dear all,
It might be a FAQ, but bothered me several days.
I tried to insert a BLOB,acturally a picture,
into a table. but always got SQL error.
this is what I do.
$sth=$dbh->prepare("insert into photo values (?,?)");
$sth->bind_param(1,'2001-10-27');
$sth->bind_param(2,$image,SQL_BINARY);
$sth->execute;
Please correct me or provide a code sample.
Thanks,
Vincent Chen
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
