level 1
LLLLvu
楼主
$sql = "SELECT a.id,a.tel,a.title,a.cityid,a.userid,a.contact_who,a.content,a.img_path,a.img_count,a.upgrade_type,a.upgrade_type_list,a.upgrade_time,a.upgrade_time_list,a.upgrade_time_index,a.begintime,a.endtime,a.info_level,a.certify,a.ifred,a.ifbold,a.dir_typename,a.contact_who,b.areaname,c.cityname FROM
{$db_my}information AS a LEFT JOIN ,{$db_my}city AS c ON `{$db_my}area` AS b ON a.areaid = b.areaid WHERE a.id IN ($idin) {$orderby}";
请教一下我想增加一项查询城市的sql查询语句但是一直提示语句错误原本只查询地区的 我增加了这项,{$db_my}city AS c ON 大神语句有错吗 帮忙看看
2017年10月31日 09点10分
1
{$db_my}information AS a LEFT JOIN ,{$db_my}city AS c ON `{$db_my}area` AS b ON a.areaid = b.areaid WHERE a.id IN ($idin) {$orderby}";
请教一下我想增加一项查询城市的sql查询语句但是一直提示语句错误原本只查询地区的 我增加了这项,{$db_my}city AS c ON 大神语句有错吗 帮忙看看