Here is the full code for your reference:
if($qry == "ok"){
// get db connection
include("/*/*/opendb.php");
$select = "SELECT 'A' AS 'Transaction Type', student AS 'Student Name', address AS 'Student Address', telephone AS 'Telephone number', spouse AS 'Spouse Name', spouse address AS 'Spouse Address', spouse telephone AS 'Spouse Telephone'
FROM intenrollment
WHERE confirm = 'Y' and amountpaid != '0';
if ( $smon != "None" and $sday != "None" and $syear != "None" and $emon != "None" and $eday != "None" and $eyear != "None" )
{
$startdate = strtotime("$smon $sday, $syear");
$enddate = strtotime("$emon $eday, $eyear");
$select .= "AND applydate BETWEEN $startdate AND $enddate ";
} elseif ( $smon != "None" and $sday != "None" and $syear != "None" ) {
$startdate = strtotime("$smon $sday, $syear");
$select .= "AND applydate > $startdate ";
} elseif ( $emon != "None" and $eday != "None" and $eyear != "None" ) {
$enddate = strtotime("$emon $eday, $eyear");
$select .= "AND applydate < $enddate ";
}
$select .= "ORDER BY school ASC, lname ASC";
// run query
$export = mysql_query($select) or die(mysql_error());
$fields = mysql_num_fields($export);
$export2 = mysql_query($select2) or die(mysql_error());
// get field info for headers
$header = '';
for ( $i = 0; $i < $fields; $i++ )
{
$header .= mysql_field_name($export, $i) . "\t";
}
// extract data and convert into excel readable format
$data = '';
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";
// ^
// Added an equal sign
}
$line .= $value;
}
$data .= trim($line)."\n";
}
$data = str_replace("\r", "", $data);
// return message if query returns no data
if ( $data == "" )
{
$data = "\n(0) Records Found!\n";
}
// setup headers with no caching
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=data.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";
} else {
?>
<style>
body,td,table {font-family:Arial; font-size:10px;}
select {font-family:Arial; font-size:12px;}
</style>
<table align="center">
<tr><td align=center><a href="index.php"><font size=2>Back to Menu</font></a></td></tr>
<tr><td>
<form action="extracttest.php" method="post">
Start:
<select name='smon' size='1'>
<option value="None">Month</option>
<option value='January'>January</option>
<option value='February'>February</option>
<option value='March'>March</option>
<option value='April'>April</option>
<option value='May'>May</option>
<option value='June'>June</option>
<option value='July'>July</option>
<option value='August'>August</option>
<option value='September'>September</option>
<option value='October'>October</option>
<option value='November'>November</option>
<option value='December'>December</option>
</select>
<select name="sday">
<option value="None">Day</option>
<?
for($ctr=1; $ctr<=31;++$ctr){
if($row[sday] == $ctr){
print("<option value='$ctr' selected>$ctr</option>");
}
else{
print("<option value='$ctr'>$ctr</option>");
}
}
echo "</select> ";
echo "<select name='syear' size='1'>";
$today = getdate();
$yr = $today['year'];
?>
<option value="None">Year</option>";
<option value='2006'>2006</option>";
<option value='2007'>2007</option>";
<option value='2008'>2008</option>";
<option value='2009'>2009</option>";
<option value='2010'>2010</option>";
<option value='2011'>2011</option>";
</select> -
End:
<select name='emon' size='1'>
<option value="None">Month</option>
<option value='January'>January</option>
<option value='February'>February</option>
<option value='March'>March</option>
<option value='April'>April</option>
<option value='May'>May</option>
<option value='June'>June</option>
<option value='July'>July</option>
<option value='August'>August</option>
<option value='September'>September</option>
<option value='October'>October</option>
<option value='November'>November</option>
<option value='December'>December</option>
</select>
<select name="eday">
<option value="None">Day</option>
<?
for($ctr=1; $ctr<=31;++$ctr){
if($row[eday] == $ctr){
print("<option value='$ctr' selected>$ctr</option>");
}
else{
print("<option value='$ctr'>$ctr</option>");
}
}
echo "</select> ";
echo "<select name='eyear' size='1'>";
$today = getdate();
$yr = $today['year'];
?>
<option value="None">Year</option>";
<option value='2006'>2006</option>";
<option value='2007'>2007</option>";
<option value='2008'>2008</option>";
<option value='2009'>2009</option>";
<option value='2010'>2010</option>";
<option value='2011'>2011</option>";
</select>
<input type="submit" value="Select">
<input type="hidden" name="qry" value="ok">
</tr>
<tr><td align=center style="font-famiy:Tahoma; font-size:12px; color:777777;">If you do not enter a date, all records will be displayed.</td></tr>
</form>
</table><p>
<?
}
?>
This is considering that let's say spouse != null, I would like it to go to the 2nd row and so on until there are no data to extract.