// get the national countries from the db
// exclude the international leagues
// and the leagues that have the same results
// (eg. serbia & serbia/montenegro)
= "SELECT c.name, c.id
FROM country_season c
INNER JOIN active_season a ON a.sid = c.sid
WHERE c.name NOT LIKE '%(%'
AND c.name NOT LIKE '%FRIENDLY%'
AND c.name NOT LIKE '%INTERNATIONAL%'
AND c.name NOT LIKE '%OLYMPIC%'
AND c.name NOT LIKE '%MEDITERRANEAN%'
AND c.name NOT LIKE '%ASIA%'
AND c.name NOT LIKE '%NATIONAL%'
AND c.name NOT LIKE '%SCANDINAVIA%'
AND c.name NOT LIKE '%CUP%'
ORDER BY c.name";
= mysql_query ();
// count the total competitions of the national countries
=
"SELECT COUNT(a.id)
FROM active_comps a
INNER JOIN country_season cs ON cs.id = a.cid
INNER JOIN active_season ase ON ase.sid = cs.sid
WHERE a.cup_id IS NULL
AND cs.name NOT LIKE '%(%'
AND cs.name NOT LIKE '%FRIENDLY%'
AND cs.name NOT LIKE '%INTERNATIONAL%'
AND cs.name NOT LIKE '%OLYMPIC%'
AND cs.name NOT LIKE '%MEDITERRANEAN%'
AND cs.name NOT LIKE '%ASIA%'
AND cs.name NOT LIKE '%NATIONAL%'
AND cs.name NOT LIKE '%SCANDINAVIA%'
AND cs.name NOT LIKE '%CUP%'";
= mysql_query ();
= mysql_fetch_row ();
?>