Team
表有:ID |团队-+-1|A 2| B
Result
表有:fk_ID1 | fk_ID2 |结果-+-1|2| 5:0 2|1| 2:3
如何获取表格,获取:(A 5:0 B) & (A 2:3 B)
我的代码示例:
public function getResultList($limit, $offset) {
$query = " SELECT result_id,
t1.name name1,
t2.name name2,
team1_goals,
team2_goals,
date
FROM results
INNER JOIN team t1 ON fk_tm1_id=tm_id
INNER JOIN team t2 ON fk_tm2_id=tm_id";
$data = mysql::select($query);
return $data;
}
https://stackoverflow.com/questions/50785763
复制相似问题