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`"; 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. 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.. 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. 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. 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 Link to comment https://forums.phpfreaks.com/topic/249835-select-count-query-problem/#findComment-1282463 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.