I am looking for a way to export to excel instead of printing, I know how to just make an excel file from a database but I need to add Query's and calculations before I export this out to excel, here is the code, I appreciate any Ideas.
while ($row1 = mysql_fetch_array($result1)) {
$vin = $row1["VIN"];
$maxclosedate = $row1["MAX(CLOSEDATE)"];
$dateexpire = date("Y-m-d" , (strtotime($todaysdate) + (60*60*24*90)));
$lastremindersent = $row1["last_reminder_sent"];
$lastremindersentserviceday = $row1["last_reminder_sent_serviceday"];
$lastremindersentincrement = $row1["last_reminder_sent_increment"];
$misseddate = date("Y-m-d" , (strtotime($todaysdate) - (60*60*24*8)));
$missed = date("Y-m-d" , (strtotime($lastremindersentserviceday) + (60*60*24*7)));
if($lastremindersent > $maxclosedate && $missed > $misseddate && $missed < $todaysdate){
print"
<tr>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row1["CUSTOMERNAME"]}</font></td>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row1["ADDRESS"]}</font></td>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row1["CITY"]}, {$row1["STATE"]} {$row1["ZIP"]}</font></td>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row1["MAKE"]}</font></td>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row1["MODEL"]}</font></td>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row1["YEAR"]}</font></td>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row1["VIN"]}</font></td>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>$lastremindersentserviceday</font></td>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>$lastremindersentincrement</font></td>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>$todaysdate</font></td>
<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>$dateexpire</font></td>
</tr>";
Thanks,
