$query="select proclass.b_name,proclass.s_name,prolist.p_id,prolist.p_name,prolist.p_img,prolist.content from prolist,proclass where proclass.id=prolist.c_id order by prolist.id desc";出错信息为:
Notice: Trying to get property of non-object in C:\wamp\www\trade\chadmin\cplist.php on line 16
Notice: Trying to get property of non-object in C:\wamp\www\trade\chadmin\cplist.php on line 16
$query="select a.b_name,a.s_name,b.p_id,b.p_name,b.p_img,b.content from prolist a ,proclass b where a.id=b.p_id order by a.id desc";
$query="select proclass.b_name,proclass.s_name,prolist.p_id,prolist.p_name,prolist.p_imgprolist.content from prolist left join proclass on(prolist.id=proclass.id) where proclass.id=prolist.c_id order by prolist.id desc";
提示试图获取空对象的属性.
我的都是:Unknown column 'ju.timesd' in 'field list';
不知道是不是我用的函数不一样,不过,觉得这个不是SQL语句的错误。