Table/Array display question

lmayer4

Afternoon,

I have a report that a department wants to look like this:

Summary July August September

of tests 100 80 60

Negative 50 20 10
Positve 50 60 30

What I have displays like

July

of tests 100

Negative 50
Positive 50

August

of tests 80

Negative 20
Positive 60

I've put the code below if anyone can point me in the right direction I would most appreciate it.

Thanks

Laura

/* connect to db */
include ("Connect.php");
// Begin your table 
echo "<table>";
$sql_events = mssql_query("SELECT  * FROM dbo.vwTestReport") or die (mssql_error());
while ($row = mssql_fetch_array($sql_events)) 
{
$myArray[$row[0]] = $row[1];
    //now we expand it
    while(list($MonthCount) = each($myArray)) 
		{
		echo "<tr class=tr><td colspan=14><hr></td></tr>";
		echo "<tr class=tr><td colspan=4><b>$MonthCount </b></td>";
		}
echo "
	<tr><td bgcolor='$row_color'>THC</td><td>" .$row['THC'] ."</td></tr>
	<tr><td bgcolor='$row_color'>COC</td><td>" .$row['COC'] ."</td></tr>
	<tr><td bgcolor='$row_color'>OPI</td><td>" . $row['OPI'] ."</td></tr>
	<tr><td bgcolor='$row_color'>OXY</td><td>" . $row['OXY'] ."</td></tr>
	<tr><td bgcolor='$row_color'>MTD</td><td>" . $row['MTD'] ."</td></tr>
	<tr><td bgcolor='$row_color'>MDMA</td><td>" . $row['MDMA'] ."</td></tr>
	<tr><td bgcolor='$row_color'>AMP</td><td>" . $row['AMP'] ."</td></tr>
	<tr><td bgcolor='$row_color'>METH</td><td>" . $row['METH'] ."</td></tr>
	<tr><td bgcolor='$row_color'>PCP</td><td>" . $row['PCP'] ."</td></tr>
	<tr><td bgcolor='$row_color'>Other</td><td>" . $row['Other'] ."</td></tr>";
$row_count++;
}
echo "</table>";