RE: [PHP] assignment of data into a 2 dimensional array
| From: | Jay Blanchard | Date: | Mon, 03 May 2004 21:00:22 +0000 |
| Subject: | RE: [PHP] assignment of data into a 2 dimensional array | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-185256@lists.php.net to get a copy of this message | ||
[snip]
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.
[/snip]
If I am reading this right you want something like this?
| Usage By Date |
CardNumber-> | 2903 | 2904 | 5781 |
Date---------|------|------|------|
2004-01-01 | 21 | 0 | 7 |
2004-01-02 | 2 | 3 | 4 |
2004-01-03 | 0 | 3 | 2 |