[PHP] Dynamic Date Select and SQL

2002-02-15 Thread Simon H
I have a problem I hope someone can help me with... Firstly I have an SQL Query with a WHERE dateMonthAndYear = $month1 Already this shows part of what I'm trying to do. The date format in the DB is -MM-DD HH:MM:SS. Now I need to dynamically generate a pulldown of months... The range of

RE: [PHP] Dynamic Date Select and SQL

2002-02-15 Thread Rick Emery
| 2002-04-01 12:00:00 | Apr 2002 | | 200205 | 2002-05-01 12:00:00 | May 2002 | ++-+--+ 5 rows in set (0.05 sec) -Original Message- From: Simon H [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 6:32 AM To: PHP General Subject: [PHP] Dynamic Date

RE: [PHP] Dynamic Date Select and SQL

2002-02-15 Thread Simon H
To: 'Simon H'; PHP General Subject: RE: [PHP] Dynamic Date Select and SQL Sensitivity: Confidential If I understand your question, you are looking for the MYSQL sql statement. Based upon your info, I've found something like this example: mysql describe