select count(*) as cnt from g4_board_new N inner join g4_board B using( bo_table) where B.gr_id='원하시는 그룹'

오늘의 조건이 빠진것 같은디..음..

sql이 좀 틀렸네요.
$today= date('Y-m-d 00:00:00');
$today2= date('Y-m-d 24:59:59');

"select count(*) as cnt from g4_board_new N inner join g4_group G using( bo_table) where G.gr_id='원하시는 그룹' and bn_datetime between $today and $today2 "