2d Table

[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.

[protocode]

I messed up, I meant for this to be in PHP, sorry.

[physics]

Welcome to WebmasterWorld.com protocode!

Something like this should do the trick:

1) Find out string length of longest entry in each column
(for example use

SELECT MAX( LENGTH( column1 ) ), MAX( LENGTH( column2 ) ) FROM `tablename`; 

Save this in an array
For each column, check if the column name itself is longer than any of these and if so update the max length array with that number

2) * When printing each row/column use the 'str_pad' function [php.net...] to print each field with the correct number of spaces

That should get you started anyway :)