I now have a working script...
Here is the final product:
<?php
$db = new dbstuff;
$team = $_GET['team'];
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
$sql = "select teamname from teams where id=".$team;
$query = $db->query($sql);
list($teamname)=$db->fetch_row($query);
$sql = "select g.gamenum, ";
$sql = $sql." DAYNAME(g.gamedate) gamedayname, ";
$sql = $sql." MONTHNAME(g.gamedate) gamemonthname, ";
$sql = $sql." DAYOFMONTH(g.gamedate) gamedaynum, ";
$sql = $sql." lower(date_format(g.gamedate, '%l:%i')) gametime, ";
$sql = $sql." h.teamname, ";
$sql = $sql." v.teamname, ";
$sql = $sql." f.field_name ";
$sql = $sql."from games g, ";
$sql = $sql." teams v, ";
$sql = $sql." teams h, ";
$sql = $sql." _fields f ";
$sql = $sql."where g.homeid = h.id and ";
$sql = $sql." g.visitorid = v.id and ";
$sql = $sql." f.id = g.fieldid and ";
$sql = $sql." (g.homeid=".$team." or g.visitorid=".$team.") ";
$sql = $sql."order by g.gamenum";
$query = $db->query($sql);
if (!$query) {
echo('Team:'. $team.mysql_error());
} else {
$content = "GameNo\tGame Day\tGame Time\tHome\tVisitor\tField\n";
// Get results
while (list($gameno, $gamedayname, $gamemonthname, $gamedaynum, $gametime, $hometeam, $visitteam, $field_)=$db->fetch_row($query)) {
$content = $content."$gameno\t$gamedayname $gamemonthname $gamedaynum\t$gametime\t$hometeam\t$visitteam\t$field_\n";
}
}
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: inline; filename=".$teamname."_schedule.xls");
header("Content-Length: " . strlen($content));
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: public");
echo("$content");
?>
Of course, with no formatting...
Is there a way to do Excel via COM on a Linux box?
