Adobe Reader could not open 'filename.pdf'" because it is either not a supported file type...

Hi i have solved the ie bug creating the pdf phisically, this is the code i use:

$hostname = "XXXXXX";
$database = "XXXXX";
$username = "XXXXX";
$password = "XXXXXX";
$db = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);

mysql_select_db($database, $db);
$query_rs_docs = "SELECT * FROM doc WHERE doc_name='".$_GET['doc_name']."'";
$rs_docs = mysql_query($query_rs_docs, $db) or die(mysql_error());
$row_rs_docs = mysql_fetch_assoc($rs_docs);
$totalRows_rs_docs = mysql_num_rows($rs_docs);

$t_pdf = fopen("/path to doc folder/doc/".$row_rs_docs['doc_name'], "w+");

fwrite($t_pdf, $row_rs_docs['doc_file']);
fclose($t_pdf);

header('Location: http://www.portalesardegna.com/doc/'.$row_rs_docs['doc_name']);

the db table (doc_name must contain the .pdf extension):

CREATE TABLE IF NOT EXISTS `doc` (
  `doc_ID` int(10) NOT NULL auto_increment,
  `doc_name` varchar(255) NOT NULL,
  `doc_file` longblob NOT NULL
  PRIMARY KEY  (`doc_ID`)
) ENGINE=MyISAM;

Message was edited by: Portale Sardegna

Were you able to solve this issue.  I am having the same issue now.  I have an app which generates reports and sends it as an attachment to senior managers.  but they are not able to open the report.  We all see the above error you mention.

When you download the file using IE 7/8 it actually comes over as 0KB. Thus not containing any information. However using the smae computer and downloading the file using Firefox it contains all the information.

Any suggestions?

Sounds that you want to read your .pdf files on your Mobile device,maybe iPhone, but failed? If that, you need to know that it is normal, because most of mobile device supports .pdf file veiwing poorly. The right way is to change the format from .pdf to .epub. Hope this would do you some indirections.