$sql="SELECT id,COUNT(id) countb FROM table WHERE `id` = '43' and year(`today_insert`) = '2011' and month(`today_insert`) = '09' GROUP BY id ORDER BY countb";
$sql="SELECT id,COUNT(id) countb FROM table WHERE `id` = '43' and date_format(today_insert, '%Y%m') between '201109' and '201110' GROUP BY id ORDER BY countb";