Help with building the file name for export doc

[hane]

Hi for some reason I just cant get my code to work. Please take a look and help me in the right direction.

 

Here is my header builder for my export doc, $vExcelFileName is my problem:

<?php require_once('includes/connect.php');

$adid=$_GET['adid'];

mysql_select_db($database_A, $A);
$query_ads = "SELECT * FROM ads JOIN company ON ads.companyid=company.companyid JOIN contact ON contact.companyid=ads.companyid WHERE adid=$adid";
$ads = mysql_query($query_ads, $A) or die(mysql_error());
$row_ads = mysql_fetch_assoc($ads);
$totalRows_ads = mysql_num_rows($ads);

$vExcelFileName=$row_ads['name'] . "ad-description-" .  $row_ads['month'] ."-10" .  ".doc";
header("Content-type: application/x-ms-download"); //#-- build header to download the excel file
header("Content-Disposition: attachment; filename=$vExcelFileName");
header('Cache-Control: public');
?>

 

I'm sure its something silly that I'm not seeing and just need someone else to point it out

[phpchamps]

whats the exact problem???

 

if you are not getting variable value.. try something like this

 

header("Content-Disposition: attachment; filename=\"$outname\";\n\n");

[hane]

I have checked the code and it works, but when a name has spaces it falls apart how can I fix that

Here is the problem:

 

$vExcelFileName=$row_ads['name'] . "ad-description-" .  $row_ads['month'] ."-10" .  ".doc";

[phpchamps]

i run the code and its working fine at my machine.. even though... it has spaces in name...

[hane]

When I run the code for Company lets say AIP Africa for June the file name is supposed to be:

aipafrica-ad-description-jun-10.doc what I get is AIP

[phpchamps]

and whts the filename do you get in that case????

[hane]

what I get is AIP

[phpchamps]

are you sure your query is not returning multiple rows?????

 

please post the result of your query..

[hane]

remember i call the info from my mysql database so I select AIP Africa from drop down then I select export and it exports all the info to a .doc file with the name populated with my the script in question

[hane]

the easies would be to show you

 

Go to http://www.hefty.co.za/agrisales/

 

Select Excaload from drop down submit then select PDF to see working example

Select AIP Africa from drop down submit then select PDF to see problem

[hane]

I fixed it with urlencode.

 

 

[hane]

Please tell me if there is a better way

[hane]

Think I found a better way:

$n= $row_ads['name'];
$na= preg_replace('/\s*/m','',$n);
$vExcelFileName= $na ."-ad-description-" . $row_ads['month'] . "-10" . ".doc";