试试 Select ID,user_name,sex,edu,job,lastlogin From person where check='y' AND wantto Like '%广东省%' And (TO_DAYS(CURDATE())-TO_DAYS(DATE_FORMAT(lastlogin,'%Y-%m-%d')))<=7
是我搞错了一个参数不好意思,不过还是谢谢大家参与我在PHP里用 if($job=="") $query_string = " Select ID,user_name,sex,edu,job,lastlogin From person where check='y' AND wantto Like '%$aera%' And (TO_DAYS(NOW())-TO_DAYS(lastlogin))<=$postdate"; 因为搜索时$job一直是不为空的,所以 $query_string就是空的了 我头晕了
Select ID,user_name,sex,edu,job,lastlogin From person where check='y' AND wantto Like '%广东省%' And (TO_DAYS(CURDATE())-TO_DAYS(DATE_FORMAT(lastlogin,'%Y-%m-%d')))<=7
if($job=="")
$query_string = "
Select ID,user_name,sex,edu,job,lastlogin From person where check='y' AND wantto Like '%$aera%' And (TO_DAYS(NOW())-TO_DAYS(lastlogin))<=$postdate";
因为搜索时$job一直是不为空的,所以
$query_string就是空的了
我头晕了