Greetings all, I can't get LOAD_FILE to work in an INSERT statement
from PHP. The generated sql works when you're in mysql but won't work
from PHP.
BSDB is my database object.
sql_query basically just does a mysql_query and some error outputting
stuff. There error is:
Column 'photo' cannot
Jough P wrote:
Greetings all, I can't get LOAD_FILE to work in an INSERT statement from
PHP. The generated sql works when you're in mysql but won't work from PHP.
BSDB is my database object.
sql_query basically just does a mysql_query and some error outputting
stuff. There error is:
Column
I've tried a couple different paths and double checked them.
Permissions are 755. Like I said that exact same SQL statement inserts
the correct record from the mysql command line.
mysql INSERT INTO photo VALUES('',
LOAD_FILE(/Library/WebServer/Documents/var/tmp/default_smiley.png));
does
Greetings all, I'm still having problems with LOAD_FILE. If anyone is
using it and could post some examples that would be fabulous.
Thanks tons!!!
On Jan 16, 2004, at 9:12 AM, Jough P wrote:
Greetings all, I can't get LOAD_FILE to work in an INSERT statement
from PHP. The generated sql
On Saturday 17 January 2004 03:44, Jough P wrote:
On Jan 16, 2004, at 9:12 AM, Jough P wrote:
Greetings all, I can't get LOAD_FILE to work in an INSERT statement
from PHP. The generated sql works when you're in mysql but won't work
from PHP.
Are you using the same user in both cases? The
OMG I'm sure that's why I'm having problems. Do you know the syntax
for granting the file_priv? The following doesn't seem to work:
mysql GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY
'password123';
On Jan 16, 2004, at 3:15 PM, Jason Wong wrote:
On Saturday 17 January 2004
6 matches
Mail list logo