RE: [PHP-DB] help with file downloads from MySQL

If you load the data into the field with addslashes, have you tried stripslashes on the way out? Bastien

From: "Mickey Martin" <Mickey.Martin@alcatel.com> To: php-db@lists.php.net Subject: [PHP-DB] help with file downloads from MySQL Date: Tue, 21 Mar 2006 12:55:56 -0600 Every time I try to download a file from MySQL it cannot be opened. Using HexEdit, I noticed that all of the files are getting 0a added to the beginning of them (happens with all browsers). I can look at the files with MySQL Query Browser and they don't have the 0a. Using php 4.3.11, Solaris 8, Apache 2.0.54, MySQL 4.1.11. Here's what I'm using: mysql_select_db($database_ctnwww, $ctnwww); $query_Attachment = sprintf("SELECT bin_data, filetype, filename, filesize FROM IssueAttach WHERE id_files=%s", $_GET['id_files']); $Attachment = mysql_query($query_Attachment, $ctnwww) or die(mysql_error()); $row_Attachment = mysql_fetch_array($Attachment); $data = $row_Attachment['bin_data']; $name = $row_Attachment['filename']; $size = $row_Attachment['filesize']; $type = $row_Attachment['filetype']; header("Content-type: $type"); header("Content-length: $size"); header("Content-Disposition: attachment; filename=$name"); header("Content-Description: PHP Generated Data"); echo $data; Thanks in advance, Mickey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php