PHP如何按日期查询

 
'> 
'>
'>
'>
     

回复讨论(解决方案)

FROM_UNIXTIME() UNIX时间戳转换为日期
UNIX_TIMESTAMP() 日期转换为UNIX时间戳

$u = $_GET['u'];$starttime = strtotime($u.'000000');$endtime =  strtotime($u.'235959');$runSql = mysql_query("select * from cmsdj_song where addtime > '$starttime' and addtime<'$endtime' order by id desc limit ".$p.",".$col."");