RE: [PHP] mysql load_file retreival

2003-12-20 Thread Larry Brown
: PHP List Subject: RE: [PHP] mysql load_file retreival Gald to hear it works now. Are you base64 encoding it for any particular reason? Seems to me that it would waste a lot of db space as base64 encoding adds quite a bit to the filesize. Chris -Original Message- From: Larry Brown [mai

RE: [PHP] mysql load_file retreival

2003-12-20 Thread Chris
:16 PM To: Chris; PHP List Subject: RE: [PHP] mysql load_file retreival Thanks for the help. I went through a troubleshooting phase that started with writing the raw data from the mysql client to disk. Checking the size it was apparent that it was much too small. I tried running my script with

RE: [PHP] mysql load_file retreival

2003-12-20 Thread Larry Brown
EMAIL PROTECTED] Sent: Saturday, December 20, 2003 3:49 PM To: PHP List Subject: RE: [PHP] mysql load_file retreival Try looking at the data that's supposed to be outputing the pdf. Something may be failing somewhere and you might see an error message. If you don't see any error messages and

RE: [PHP] mysql load_file retreival

2003-12-20 Thread Chris
r print's, that would very likely cause the pdf to not be able to be read properly. Chris -Original Message- From: Larry Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, December 20, 2003 10:36 AM To: Chris; PHP List Subject: RE: [PHP] mysql load_file retreival Oops, my bad on the pos

RE: [PHP] mysql load_file retreival

2003-12-20 Thread Larry Brown
2003 1:24 PM To: PHP List Subject: RE: [PHP] mysql load_file retreival LOAD_FILE() shouldn't be escaping the data. Are you actually calling : echo header()? the header function should not be echoed. header('Content-type: application/pdf'); echo result[0]; -Original Message---

RE: [PHP] mysql load_file retreival

2003-12-20 Thread Chris
r 20, 2003 9:29 AM To: PHP List Subject: [PHP] mysql load_file retreival I have set up a script to recieve a pdf file and store it in a mysql db using "update db set field=load_file('fileIncludingFile') where id=$id". Afterwards I can see the file has been uploaded into the

[PHP] mysql load_file retreival

2003-12-20 Thread Larry Brown
I have set up a script to recieve a pdf file and store it in a mysql db using "update db set field=load_file('fileIncludingFile') where id=$id". Afterwards I can see the file has been uploaded into the blob field successfully and without errors. Now I want to get the file back out. I set up a scr