讯睿CMS问答:为何语句这么写,没有数据显示呢?

讯睿CMS问答:为何语句这么写,没有数据显示呢?

2024-06-29 XunRuiCMS Sincere

问题:


11111.jpg

为何语句这么写,{php $query='select a.*,b.* from @#bjd as a,@#member as b where a.uid=b.uid and b.kid={$member[uid]} and a.mid="news"';},没有数据显示呢?只有b.kid=数字时,才会显示呢?

答案:

{php $query=urlencode('select a.*,b.* from @#bjd as a,@#member as b where a.uid=b.uid and b.kid='.intval($member.uid).' and a.mid="news"');}

回复@长沙小陈:如果要用inputtime排序的话,怎么写?我加了order=inputtime,没作用