Check for more than 1 record and save to excel file

[dmacman1962]

Hi all,

I have a drop down box to choose a state in a html form. When you hit submit, it runs this code and looks up wether or not there are any records for that state and prompts you to save an excel file.

This works great if their are any records, but it prompts to save the file out if there is no records.

I've tried num-rows, ! $select, etc. and I cannot get it to display the "There are no records to display" message.

Here is my code:

<?
//make db conncetion
$conn = mysql_connect("x", "x", "x") 
  OR DIE (mysql_error());
@mysql_select_db ("x", $conn) OR DIE (mysql_error());

//get the data from the state drop down
$State = addslashes($_POST['State']);

//echo 'The state picked is: '.$State;

//export the data
$select = "SELECT * FROM Forms WHERE State='$State'"; 
//$select = "SELECT * FROM Forms";  

//$num_rows = mysql_num_rows($select);
//if (mysql_num_rows < 2) {
if ( ! $select) {  

echo 'There are no records for that state.';
echo ' <br><br>';
echo '<a href="pickstate.php"> Go Back and Try again</a>';
} else {                       

$export = mysql_query($select); 
$fields = mysql_num_fields($export);  

for ($i = 0; $i < $fields; $i++) { 
    $header .= mysql_field_name($export, $i) . "\t"; 
} 
while($row = mysql_fetch_row($export)) { 
    $line = ''; 
    foreach($row as $value) {                                             

        if ((!isset($value)) OR ($value == "")) { 
            $value = "\t"; 
        } else { 
            $value = str_replace('"', '""', $value); 
            $value = '"' . $value . '"' . "\t"; 
        } 
        $line .= $value; 
    } 
    $data .= trim($line)."\r\n"; 
} 
$data = str_replace("\r","",$data);
if ($data == "") { 
    $data = "";                         

}
header("Content-type: application/x-msdownload"); 
header("Content-Disposition: attachment; filename=report.xls"); 
header("Pragma: no-cache"); 
header("Expires: 0"); 
print "$header\r\n$data";
}
?>

This will be sweet once I get this fixed.

Also, does anyone have any suggestions on how to set the "processed" field in this table, once the above code is run?

Thanks a bunch,

Don

[devinemke]

$result = mysql_query("SELECT * FROM Forms WHERE State = '$State'") or exit(mysql_error());
if (mysql_num_rows($result))
{
	// code to build excel file
}
else
{
	echo 'no records matching that state';
}

[dmacman1962]

Hi Devinmke,

When I change my code to what you suggest, if there is no record, I get the correct page.

However, if there are records, I get this error:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/inthecla/public_html/forms/export.php on line 20

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/inthecla/public_html/forms/export.php on line 24

Warning: Cannot modify header information - headers already sent by (output started at /home/inthecla/public_html/forms/export.php:20) in /home/inthecla/public_html/forms/export.php on line 41

Warning: Cannot modify header information - headers already sent by (output started at /home/inthecla/public_html/forms/export.php:20) in /home/inthecla/public_html/forms/export.php on line 42

Warning: Cannot modify header information - headers already sent by (output started at /home/inthecla/public_html/forms/export.php:20) in /home/inthecla/public_html/forms/export.php on line 43

Warning: Cannot modify header information - headers already sent by (output started at /home/inthecla/public_html/forms/export.php:20) in /home/inthecla/public_html/forms/export.php on line 44

This is the same error I get with every method I have tried so far?

Thanks,

Don

[devinemke]

if you are using my example then you need to feed $result to the resut of the mysql functions

[dmacman1962]

I am using $result, here is the code:

$result = mysql_query("SELECT * FROM Forms WHERE State = '$State'") or exit(mysql_error());
if (mysql_num_rows($result)){                     

$export = mysql_query($result); 
$fields = mysql_num_fields($export);  

for ($i = 0; $i < $fields; $i++) { 
    $header .= mysql_field_name($export, $i) . "\t"; 
} 
while($row = mysql_fetch_row($export)) { 
    $line = ''; 
    foreach($row as $value) {                                             

        if ((!isset($value)) OR ($value == "")) { 
            $value = "\t"; 
        } else { 
            $value = str_replace('"', '""', $value); 
            $value = '"' . $value . '"' . "\t"; 
        } 
        $line .= $value; 
    } 
    $data .= trim($line)."\r\n"; 
} 
$data = str_replace("\r","",$data);
if ($data == "") { 
    $data = "";                         

}
header("Content-type: application/x-msdownload"); 
header("Content-Disposition: attachment; filename=report.xls"); 
header("Pragma: no-cache"); 
header("Expires: 0"); 
print "$header\r\n$data";
} else {
echo 'There are no records for that state.';
echo ' <br><br>';
echo '<a href="pickstate.php"> Go Back and Try again</a>';
}  

With your suggestions, I am still getting those header errors???

Thanks,

Don