mysql使用left join等表连接查询时需注意的情况

来源：互联网发布：淘宝最近总是查侵权编辑：程序博客网时间：2024/04/30 09:53

使用left join right join 等关于表连接查询时，如果遇到其连接的表中有相同字段时，一定要注意区别，其中一种方式是使用select as来区分，下面是一个简单的demo

//模糊查询会员信息

function search_User_Info($keyword,$offset,$pagesize){
$sql = "SELECT *,P101.UID as UID2,P101.PHONE as PHONE2 from P101 left join E101 on P101.EID = E101.EID where(P101.UID like '%".$keyword."%')or(P101.EID like '%".$keyword."%')or(P101.NAME like '%".$keyword."%')or(E101.ENAME like '%".$keyword."%')or(P101.PHONE like '%".$keyword."%') order by P101.TIME desc limit ".$offset.",".$pagesize;
$result = exequery(GOS::conn_PES(),$sql);
$count = mysql_num_rows($result);
while($data = mysql_fetch_assoc($result)) {
$userid = $data['UID2'];
$eid = $data['EID'];
$username = $data['NAME'];
$time = $data['TIME'];
$phone = $data['PHONE2'];
$red = $data['RED_BO'];
$green = $data['GREEN_BO'];
$active = $data['ACTIVE'];

$ename = get_Ename_Byeid($eid);//获取企业名称
$user_info[] = array(
'userid' => $userid,
'eid' => $eid,
'ename' => $ename,
'username' => $username,
'time' => $time,
'phone' => $phone,
'red' => $red,
'green' => $green,
'count' => $count,
'active' => $active
);
}
return $user_info;
}

0 0