After reading some other posts on inserting a image into a blob field, I tried using DBI to insert and the following does not work...
I've double-checked the path and it is correct. $imageFN = '/var/www/htdocs/corporate/images/homenew.jpg'; $SQL = "UPDATE banners SET image=load_file('$imageFN') where id=1"; If I execute the same SQL statement at the MySQL > prompt it inserts into the database fine... what am I doing wrong? Thanks, Kevin --------------------------------------------------------------------- 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