Morning all,
I’m hoping someone can help me with the final step here. I almost have it except for a formatting issue. Using this loop I can get what I want, almost. I need it to come out looking like this:
Header row
Data Row
Total Row
What I get using this code is:
Header Row
Total Row
Data Row
Data Row…(as many data rows as there are)
I know it’s the structure but I don’t have enough experience to make this work. Any help would be appreciated.
Thanks
Laura
Below is the slimmed down version:
[code]
// first set some basic vars:
$label = “”;
include (“TFWConnect.php”);
//load it all into the associative array
$sql = “”;
$result = mssql_query($sql);
echo “<table border=1>”;
while($row = mssql_fetch_row($result))
{
if($row[0] <> $label)
{
//header row
$label = $row[0];
//totals row
}
//data row
}
echo “</table><br>”;