could you please help me? just trying to fill in some text as stackoverflow wants to write more text because it's all code
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
Your query is like:
select a.column, b.columnz from table a inner join table b on a.key = b.key
So when you get the result like:
column columnz
xxxxx yyyyyy
So your PHP
<?php echo $row["f.roundID"]?>"><?php echo $row["f.roundID"]?>
should be in this way:
<?php echo $row["roundID"]?>"><?php echo $row["roundID"]?>