RE: [PHP] assignment of data into a 2 dimensional array

[snip] Still doesn't work man, distinct isn't working properly, it still counts each swipe of the card, not discrete swipes. Thats what I'm trying to do this in PHP :) It doesn't work, its still using distinct on whatever mssql's NOW()-myssql function is before it does the date conversion, even tho that would be wrong and not following the order of operations...i guess...I dunno, all i can tell you is it doesn't work. it doesn't give the correct number when I do count(cardnum) on the dates. [/snip] I am sorry to jump into this so late and I must confess that I have not read the thread but it seems to me that what you want is a crosstab query. Have a look at this article on evolt and see if this makes sense to you.... http://www.evolt.org/article/Using_MySQL_and_PHP_to_Present_Excel_Spread sheets/20/26896/index.html