Re: unique month-year (MySQL->php)
| From: | Bobo Wieland | Date: | Wed, 05 Mar 2003 21:04:49 +0000 |
| Subject: | Re: unique month-year (MySQL->php) | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-18862@lists.php.net to get a copy of this message | ||
Hi again. I took a closer look at the archives and found the solution
myself! Sorry for not doing that first thing...
.bobo
----- Original Message -----
From: "Bobo Wieland" <dev@elstudion.com>
To: <php-windows@lists.php.net>
Sent: Wednesday, March 05, 2003 12:36 PM
Subject: [PHP-WIN] unique month-year (MySQL->php)
> 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 .
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>