PHP / SQL - PHP不会输出sql查询

Question

could you please help me? just trying to fill in some text as stackoverflow wants to write more text because it's all code

Answer 1

alias on this field

SELECT f.roundID as froundID

then use single quotes not double

$row['froundID']

AND THE BIGGER PROBLEM IS THE SQL QUERY

FROM fixtures AS f
INNER JOIN team AS h
  ON f.homeTeam = h.teamID
  AND f.awayTeam = h.teamID

which will not return anything because the awayteam and hometeam should be the same in a row...

to correct should be OR where it can be either the hometeam or awayteam

FROM fixtures AS f
INNER JOIN team AS h
  ON (f.homeTeam = h.teamID
  OR f.awayTeam = h.teamID)

with the updated requirement you need to create 3 queries
where
1 - get the rounds
2 - get the teams
3 - get the venue