will this loadÂ
can this load shortcodes
query("SELECT seasons.*,leagues.* FROM seasons LEFT JOIN matches ON seasons.season_id = matches.season_id LEFT JOIN leagues ON seasons.league_id = leagues.league_id
WHERE teama_result <> 'TBC' and leagues.league_name = '$league' GROUP BY seasons.season_id
ORDER BY start_date DESC LIMIT 1");
while($r = $stmt->fetch()){
$league_id = $r['league_id'];
$season_id = $r['season_id'];
$season_name = $r['season_name'];
$start_date = $r['start_date'];
$end_date = $r['end_date'];
$attpts = $r['attpts'];
$gd = $r['gd'];
$for_against = $r['for_against'];
$avg_percent = $r['avg_percent'];
}
echo $league "
";/*
echo $league_id "br";
echo $season_name "br";
echo $start_date "br";
echo $attpts "br";
echo $gd "br";
echo $for_against "br";
echo $avg_percent "br";
*/
?>
