Re: [PHP] Strange response to MySQL query

2006-02-14 Thread tedd
Chris and Richard: I think you both hit the nail on the head. After a few more hours of looking, reading, coding, and getting the same "Access denied.." error, I think I see what's happening (besides having a headache). It appears that my code has the permission to do what it wants, but I c

Re: [PHP] Strange response to MySQL query

2006-02-14 Thread Richard Lynch
On Tue, February 14, 2006 11:50 am, tedd wrote: > Hi gang: > > I'm trying to dump a BLOB into a file for subsequent processing. > > To do this I'm using the query statements: > > $dbQuery = "SELECT image "; > $dbQuery .= "FROM flowers "; > $dbQuery .= "WHERE image_Id=$pic_id "; > $dbQuery .= "INTO

Re: [PHP] Strange response to MySQL query

2006-02-14 Thread Chris
To do this I'm using the query statements: $dbQuery = "SELECT image "; $dbQuery .= "FROM flowers "; $dbQuery .= "WHERE image_Id=$pic_id "; $dbQuery .= "INTO DUMPFILE '/tmp/test.jpg' "; But, it generates an "Access denied.." error. However, if I comment-out the last line, namely "INTO DUMPFILE