Re: [PHP-WIN] unique month-year (MySQL->php)

2003-03-05 Thread Bobo Wieland
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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 12:36 PM Subject: [PHP-

[PHP-WIN] unique month-year (MySQL->php)

2003-03-05 Thread Bobo Wieland
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";