0 )
{
$db = new dbquery();
$db->connect();
//Requete
$db->query("SELECT b.BOROUGH_ID, b.BOROUGH_LABEL, e.EPCI_ID, e.EPCI_LABEL, e.TYPE, co.COMMUNE_ID, co.COMMUNE_LABEL
FROM ".$_SESSION['tablename']['communes']." co LEFT JOIN ".$_SESSION['tablename']['borough']." b ON co.BOROUGH_ID = b.BOROUGH_ID
LEFT JOIN ".$_SESSION['tablename']['epci']." e ON co.EPCI_ID = e.EPCI_ID WHERE co.COMMUNE_ID = '".$_POST['commune']."'");
$res = $db->fetch_object();
//Requete pour la gestion des cantons
$db->query("SELECT c.CANTON_ID, c.SEQUENCE, c.CANTON_LABEL
FROM ".$_SESSION['tablename']['cantons']." c LEFT JOIN ".$_SESSION['tablename']['communes']." co ON c.CANTON_ID = co.CANTON_ID
WHERE co.COMMUNE_ID = '".$_POST['commune']."'");
$cantons = array();
$i = 0;
while( $res2 = $db->fetch_object() ){
$cantons[$i] = array('ID'=>$res2->CANTON_ID, 'SEQ'=>$res2->SEQUENCE, 'LABEL'=>$res2->CANTON_LABEL);
$i++;
}
}
?>