I'm trying to present a simple SELECT statement "GROUPED" by date.
Ex.
WO UNITS OEM COMMENTS DATE
123 10 Me Notes 03/18/2003
456 5 You More Notes 03/18/2003
Total 15
...
I have it working grouping the dates together, but I can't seem to get the
Total Units for a group. You'll see $body .= " instead of echo... because
this is sent as an email. Here is the relevent code:
<?php
//table headers
...
while($row = mssql_fetch_array($result)) {
// $row[10] = SHIP DATE (What I'm grouping by)
// $row[0] = Unit Qty (What I want to SUM, based on each "Group")
If ($lastship!='') { // skip the first record
If ($lastship!=$row[10]) {
$body .= "<tr>\n";
$body .= "<td><strong>Total</strong>\n";
$body .= "</td>\n";
$body .= "<td align=center><strong>$total</strong>\n";
$body .= "</td>\n";
$body .= "<td colspan=5>\n";
$body .= "</td>\n";
$body .= "</tr>\n";
$totqty=0;
$lastqty=0;
}
$total=0;
}
$totqty=$lastqty+$row[0];
$total = $totqty+$total;
$lastship = $row[10];
$lastqty=$row[0];
$body .= "<tr>\n";
$body .= "<td align=\"center\">\n";
$body .= "$row[11]\n";
$body .= "</td>\n";
$body .= "<td align=\"center\">\n";
$body .= "$row[0]\n";
$body .= "</td>\n";
$body .= "<td align=\"center\">\n";
$body .= "$row[1]\n";
$body .= "</td>\n";
$body .= "<td>\n";
$body .= "$row[12]\n";
$body .= "</td>\n";
$body .= "<td align=\"center\">\n";
$body .= "$row[8]\n";
$body .= "</td>\n";
$body .= "<td align=\"center\">\n";
$body .= "$row[9]\n";
$body .= "</td>\n";
$body .= "<td align=\"center\">\n";
$body .= "$row[10]\n";
$body .= "</td>\n";
$body .= "</tr>\n";
}
...
//close table, html
?>
Any help is appreciated.
Thanks,
Mike Smith
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
