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

On Mon, 3 May 2004, Jay Blanchard wrote: > [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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > Hi, I looked at the link, but I need to get the discrete cardnum count by date, not the distinct, there doesn't appear to be a way to do it in mssql, so I have to use php to get rid of duplicate entries and then count the remaining ones. crosstab doesn't appear to do what I need.