[protocode]

I have pulled information from my database. I need to display that information in a table with two identifiers, a row and column. Example

+-------+-------+-------+
| | 2009 | 2010 |
+-------+-------+-------+
| Jan. |(count)|(count)|
+-------+-------+-------+
| Feb. |(count)|(count)|
+-------+-------+-------+
I can query the information correctly, but displaying it is way off.

Thanks for any hints or suggestions in advance.

[wirehopper]

Please post your code.

[Jcbones]

PHP Code:

while($r = mysql_fetch_assoc($result)) {
  $myArray['Month'][$r['year']] = $r['year'];
  $myArray[$r['month']][$r['year']] = $r['count'];
}
echo '<table border="1">';       
foreach($myArray as $month => $v) {
  echo '<tr><td>' . $month . '</td>';
   foreach($v as $year => $count) {
     echo '<td>' . $count . '</td>';
   }
 echo '</tr>';
} 

More code, gets more accurate answers.