Re: [PHP] selecting based on a month in a date

2003-08-28 Thread John W. Holmes
Creative Solutions New Media wrote: Hi, Asked this on the mySQL list but it seems to be more of a PHP syntax thing that a mySQL thing. In have the following line in PHP I have a mySQL table which contains dates formatted as dates(-xx-xx) I want to select all records based on a specific mon

[PHP] selecting based on a month in a date

2003-08-28 Thread Creative Solutions New Media
Hi, Asked this on the mySQL list but it seems to be more of a PHP syntax thing that a mySQL thing. In have the following line in PHP I have a mySQL table which contains dates formatted as dates(-xx-xx) I want to select all records based on a specific month. This is my select statement S