Opening a File

[treeleaf20]

All,
I have a file that I stored on my server. I put the file name and the file type in the database. These are word and excel and pdf files. I tried to pull the file name and type from the database to fill the correct headers and open the file. It doesn't seem to be working though. Can someone please take a look at what I tried to do:

$barid = $_GET['id'];
$sql = "Select menu, menu_type from bars where id='$barid'";
$result = mysql_query($sql);
$resultset = mysql_fetch_array($result);

if($resultset['menu_type'] == "application/msword"){
$extension = ".doc";
}else if($resultset['menu_type'] == "application/pdf"){
$extension = ".pdf";
}else{
$extension = ".xls";
}
header("Content-Type: application/$resultset[menu_type]");
header("Pragma: no-cache");
header("Expires: 0");
fopen("/home/website/public_html/menus/$resultset[menu].$extension","r");

Thanks for your help in advance. This file is called viewmenu.php and it is being invoked by a URL called viewmenu.php?id=10 or something like that where the id can change. However it currently tries to open up the viewmenu.php file instead of the pdf, doc or xls file that I want it to.

[LiLaaron]

try changing this section and see if it works...

fopen("/home/website/public_html/menus/$resultset[menu].$extension","r"); 

to

fopen("/home/website/public_html/menus/$resultset[menu].".$extension."","r"); 

Aaron

[LiLaaron]

Also... you may get double fullstops...

if($resultset['menu_type'] == "application/msword"){ 
$extension = ".doc"; //You have . Extension
}else if($resultset['menu_type'] == "application/pdf"){ 
$extension = ".pdf"; 
}else{ 
$extension = ".xls"; 
} 
header("Content-Type: application/$resultset[menu_type]"); 
header("Pragma: no-cache"); 
header("Expires: 0"); 
fopen("/home/website/public_html/menus/$resultset[menu].".$extension."","r"); // here you have . plus extension = ..doc

so make it

fopen("/home/website/public_html/menus/$resultset[menu]".$extension."","r"); 

[treeleaf20]

Thanks for the help so far. It opens up the right type of application to view it but it doesn't actually use the right URL. It is still trying to open up viewmenu.php except the actual file name it downloads is viewmenu.php.xls or viewmenu.php.doc or viewmenu.php.pdf. Im not sure why this is happening. Here is my revised code. I found out that $resultset['menu'] and $resultset['menu_type'] actually had all the info I needed. Please any other suggestions are greatly appreciated. The code is:

$barid = $_GET['id'];
$sql = "Select menu, menu_type from bars where id='$barid'";
$result = mysql_query($sql);
$resultset = mysql_fetch_array($result);

if($resultset['menu_type'] == "application/msword"){
$extension = ".doc";
}else if($resultset['menu_type'] == "application/pdf"){
$extension = ".pdf";
}else{
$extension = ".xls";
}
$path = "/home/web/public_html/bars/menus/$barid/$resultset[menu]";
//echo $path;
//echo $resultset['menu_type'];

header("Content-Type: $resultset[menu_type]");
header("Pragma: no-cache");
header("Expires: 0");
fopen($path ,"r");

Thanks in advance.