您需要使用列别名并在提取调用中访问它们。而不是event.*
,明确需要的列:
$sql = "SELECT sport.name AS sportname,
country.name AS countryname,
tournament_template.name AS templatename,
tournament.name AS tournamentname,
tournament_stage.name AS stagename,
/* Use explicit column names instead of event.* */
event.name AS eventname,
event.someothercol AS someother
FROM tournament_template
...etc...
...etc...";
// Later...
while($row=MysqL_fetch_array($result))
{
echo $row['eventname'];
echo "<br>";
}