resistancem Posted January 5, 2008 Share Posted January 5, 2008 Hi all im trying to retrieve rows from my table where the month is last month, but it returns zero results. i currently have: $result = mysql_query('SELECT * FROM tickets WHERE (month(created) = (month(now())-1))'); "created" is the name of the column in the table which holds the date....just to make things clearer anyone know why it might not be working? any help greatly appreciated thanks again. Link to comment https://forums.phpfreaks.com/topic/84677-solved-previous-month-query/ Share on other sites More sharing options...
fenway Posted January 6, 2008 Share Posted January 6, 2008 How was this solved? Link to comment https://forums.phpfreaks.com/topic/84677-solved-previous-month-query/#findComment-432101 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.