//$query="SELECT div_name, page FROM divisions order by div_name"; $query="SELECT distinct div_name, page FROM divisions, fixtures WHERE fixtures.division = divisions.division order by div_name"; $res = mysqli_query ($conn, $query) or exit("The query could not be performed"); $counter2 = 0; while ($row = mysqli_fetch_array($res,MYSQLI_ASSOC)) { ?>