lukep11a Posted October 26, 2011 Share Posted October 26, 2011 The code below is part of some validation code that I have, it is supposed to count the number of entries in the table 'test_selections' where 'userid' equals the user that is logged in and where the 'transfer_in' date is a date within the current month. I am getting an error saying "Error running query Unknown column '10' in 'where clause' ". Does anybody know why this could be? I am hoping that it is something to do with the snippet of code below so I don't need to post the whole lot!! Any help would be much appreciated. $current_month = date("m"); $query = "SELECT COUNT(`userid`) as `transfers_count` FROM `test_selections` WHERE `userid` = '{$_SESSION['userid']}' AND Month(`transfer_in`) = `$current_month` GROUP BY `userid`"; Quote Link to comment https://forums.phpfreaks.com/topic/249835-select-count-query-problem/ Share on other sites More sharing options...
trq Posted October 26, 2011 Share Posted October 26, 2011 Remove all the `backticks`, they are not required. Quote Link to comment https://forums.phpfreaks.com/topic/249835-select-count-query-problem/#findComment-1282370 Share on other sites More sharing options...
lukep11a Posted October 26, 2011 Author Share Posted October 26, 2011 Thanks, I have tried it with and without the backticks and still get the same result.. Quote Link to comment https://forums.phpfreaks.com/topic/249835-select-count-query-problem/#findComment-1282372 Share on other sites More sharing options...
trq Posted October 26, 2011 Share Posted October 26, 2011 echo $query and post it. Quote Link to comment https://forums.phpfreaks.com/topic/249835-select-count-query-problem/#findComment-1282381 Share on other sites More sharing options...
PFMaBiSmAd Posted October 26, 2011 Share Posted October 26, 2011 Also, you need to test both the year and the month to match the current month. Quote Link to comment https://forums.phpfreaks.com/topic/249835-select-count-query-problem/#findComment-1282385 Share on other sites More sharing options...
lukep11a Posted October 26, 2011 Author Share Posted October 26, 2011 Thankyou all for your replies, I have managed to fix it now using your help Quote Link to comment https://forums.phpfreaks.com/topic/249835-select-count-query-problem/#findComment-1282463 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.