I'm trying to select only records from the month of March.

I've tried...

$sql = "SELECT date, title, text FROM table ORDER by date DESC WHERE `date` = DATE_SUB(CURDATE(),INTERVAL -2 month)";

and this...

$sql = "SELECT date, title, text FROM brian ORDER by date DESC WHERE `date` BETWEEN DATE_SUB(CURDATE( ) ,INTERVAL -2 MONTH) AND CURDATE( )";


Neither are working.  Can anyone help, please?



The first thing I notice is that you have quotes around date - you have written 'date' when I think it should be date.  With quotes you are looking to match exactly the letters d-a-t-e and not the contents of a field called date ...

Didn't work...I still get

Quote:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /path/to/script.php on line 88 There are no news items for this month

I should add that "date" is set as timestamp (NOW) in the DB.  

I have also tried this code

Code:

$sql = "SELECT date(2008-03-00), title, text FROM brian ORDER by date DESC";

Which does display the proper results, but the dates are messed up.

2008-03-28 reads Wednesday, December 31, 1969 - 6:00 pm with this code

Code:

echo "<div class='calendarText'>".date('l, F j, Y - g:i a', strtotime($row['date']))."</div>";

this code works

Code:

$sql = "SELECT date_col, title, text FROM brian WHERE date_col BETWEEN '2008-03-01' AND '2008-04-01' order by date_col desc";

Thanks, Graham!

---