Hi.
How do I shorten an SQL statement like this;
$teamlist = $db->sql_query("SELECT id,name FROM teams WHERE id = $row['hometeam1'], $row['hometeam2'], $row['hometeam3'], $row['hometeam4'], $row['hometeam5'], $row['awayteam1'], $row['awayteam2'], $row['awayteam3'], $row['awayteam4'], $row['awayteam5'], ORDER BY name");
Thanks for any help, still learning! :rolleyes:
