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-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 > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
