Question

以下是我的 Sql 查询, 用于给 $Fid 提供的 $Fid 值分配。请告诉我以下代码有什么问题, 这样我就可以相应删除它们。

$fid = 101;
$q =  select r_present,r_reminder 
    from z_events 
    where resident_id = ? 
        and r_added > date_sub(curdate(), interval 37 day) 
        and fascility_id= ."$fid".  
    group by r_added 
    order by r_added 
    desc limit 4 ;

Answer 1

请尝试一下:

$fid = 101;
    $q = "select r_present,r_reminder from z_events where resident_id = ? and r_added > date_sub(curdate(), interval 37 day) and fascility_id=$fid group by r_added order by r_added desc limit 4";

Answer 2

小打字错误在 fid 和 group 之间添加空格如下:

$q =  select r_present,r_reminder 
from z_events 
where resident_id = ? 
    and r_added > date_sub(curdate(), interval 37 day) 
    and fascility_id= .$fid.   
group by r_added 
order by r_added 
desc limit 4 ;

以及下一个建议:无需附上带有双重引号的美元封件

这里我假设您的字段设施_ id 是整数类型。如果字符串的字符串, 那么会添加双引号 " 。如 :

$q =  select r_present,r_reminder 
from z_events 
where resident_id = ? 
    and r_added > date_sub(curdate(), interval 37 day) 
    and fascility_id=" .$fid.  " 
group by r_added 
order by r_added 
desc limit 4 ;

友情链接