请教PHP查询当天日期数据显示出来

Question

各位老大请教PHP查询当天日期数据显示出来，现在是显示最新80条，要改为查询显示属于当天的条数，如何改，数据库日期字段是a_data

$re = $db->query("SELECT * FROM ".$table." where g_ball_1>=0 order by g_qishu desc limit 0,80", 1);
$rarr = array();
$i=0;

Answer 1

$re = $db->query("SELECT * FROM ".$table." where g_ball_1>=0 where to_days(日期字段) = to_days(now())", 1);