date('m',strtotime('22-5-2013'))
if u have date data-type then it also possible on this way ..............
date('m',strtotime($arr[1]))
in which $arr[1] is date like 22-10-2013 store in database using date data-type
2nd way ,,,,
SELECT * FROM sochvote WHERE facid=$faculty_name and YEAR( STR_TO_DATE( voteDate, '%d/%m/%Y' ) ) =$year_name ")
if u have date data-type then it also possible on this way ..............
date('m',strtotime($arr[1]))
in which $arr[1] is date like 22-10-2013 store in database using date data-type
2nd way ,,,,
SELECT * FROM sochvote WHERE facid=$faculty_name and YEAR( STR_TO_DATE( voteDate, '%d/%m/%Y' ) ) =$year_name ")