Would anyone have a good idea on how to change rows to columns? I'm creating a report where I have counts per hour. I can produce +------+-------+ | hour | count | +------+-------+ | 0 | 1 | | 1 | 0 | | 2 | 1 | | 3 | 0 | | 4 | 0 | | 5 | 0 | | 6 | 0 | | 7 | 2 | | 8 | 1 | | 9 | 0 | | 10 | 1 | | 11 | 0 | | 12 | 0 | | 13 | 0 | | 14 | 0 | | 15 | 0 | | 16 | 0 | | 17 | 1 | | 18 | 0 | | 19 | 1 | | 20 | 1 | | 21 | 0 | | 22 | 0 | | 23 | 0 | +------+-------+
And then tack on an additional column for each catagory I'm tracking. However, I want to turn this horizontal and tack on each catagory as a row. Any ideas? mediis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
