SELECT COUNT query problem

[lukep11a]

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`";

[trq]

Remove all the `backticks`, they are not required.

[lukep11a]

Thanks, I have tried it with and without the backticks and still get the same result..

[trq]

echo $query and post it.

[PFMaBiSmAd]

Also, you need to test both the year and the month to match the current month.

[lukep11a]

Thankyou all for your replies, I have managed to fix it now using your help