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. Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/84677-solved-previous-month-query/#findComment-432101 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.