unique month-year (MySQL->php)
| From: | Bobo Wieland | Date: | Wed, 05 Mar 2003 11:36:58 +0000 |
| Subject: | unique month-year (MySQL->php) | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-18853@lists.php.net to get a copy of this message | ||
Hi all!
I have a mysql table with a timestamp field. I need to get the information
on which month's and year's there are present in this table. How can I get
this info? It's important that I don't get any duplicates...
$q = "SELECT (?) AS year, (?) AS month FROM my_table ORDER BY year, month";
thanks in advance!
. bobo .