PHP 数据库三个表关联 有三个表分别为a,b,c, a表字段为:userid username,b表字段为:wbid userid content

2025-03-09 20:37:59
推荐回答(2个)
回答1:

$query = mysql_query("SELECT a.*,b.wbid,b.content, c.potoid,c.upimg FROM a LEFT JOIN b ON a.userid=b.userid LEFT JOIN c ON a.userid=c.userid");
while($rt = mysql_fetch_array($query)) {
print_r($rt);
}

回答2:

SELECT A.username,B.content,C.ipimg from A as A,B as B,C as C where A.userid="$userid" and B.userid="$userid" and C.userid="$userid"
phh循环吧后面的