在线等,帮帮忙吧,高手们!!php与Mysql的问题

[worksworks]

这是我的SQL语句:select newsdate,edition,count(*)
from record,rec_user
where ru_iuser='mgq'
and date_format(ru_idate,'%c/%e/%Y')='2/9/2006'
and ru_id=recid
group by newsdate,edition
order by newsdate,edition
newsdate是报纸日期,edition是版本号,我怎样才能根据这两个值得出记录总条数呢????高手们,帮帮小妹吧!!

[web_php]

select count(newsdate),count(edition),其他你要取出的字段
from record,rec_user
where ru_iuser='mgq'
and date_format(ru_idate,'%c/%e/%Y')='2/9/2006'
and ru_id=recid
group by newsdate,edition
order by newsdate,edition

[helloyou0]

你的语句有什么问题？