connect(); //Wildcard * if( !isset($_GET['street']) OR empty($_GET['street']) ) exit; if( $_GET['street'] == "*" ) { $like = ""; } else { $like = "AND STREET_LABEL LIKE '%".$_GET['street']."%'"; } $db->query("SELECT s.STREET_LABEL, s.STREET_ID, c.COMMUNE_ID, c.COMMUNE_LABEL, c.POSTAL_CODE, q.QUARTER_LABEL FROM ".$_SESSION['tablename']['assoc_street_quarter_communes']." asqc LEFT JOIN ".$_SESSION['tablename']['quarter']." q ON ( asqc.QUARTER_ID = q.QUARTER_ID ), ".$_SESSION['tablename']['street']." s, ".$_SESSION['tablename']['communes']." c WHERE asqc.STREET_ID = s.STREET_ID AND asqc.COMMUNE_ID = c.COMMUNE_ID AND c.COMMUNE_ID IN (".implode(",",$_SESSION['street_commune_id']).") ".$like); echo "

"; while( $res = $db->fetch_object() ) { echo "
• STREET_ID.", commune_label:'".addslashes($res->COMMUNE_LABEL)."', postal_code:".$res->POSTAL_CODE.", quarter_label:'".addslashes($res->QUARTER_LABEL)."'}\">".$res->STREET_LABEL."
"; } echo "

"; ?>