session_start(); include "inc_bdd.php"; $where = ''; if(isset($_GET['ville']) && ($_GET['ville'] != '' || $_GET['dep'] != '')){ $ville = $_GET['ville']; $dep = $_GET['dep']; $where = " && (ville like '$ville%' || cp = '$ville')".(($dep != '') ? " && dep = '$dep'" : ""); } $magasins = mysql_query("select * from magasins where lat != '0' && lng != '0' $where", $connexion); $nb_magasins = mysql_num_rows($magasins); if(!$nb_magasins && isset($_GET['ville']) && strlen($_GET['ville']) == 5){ $dep = substr($_GET['ville'], 0, 2); $magasins = mysql_query("select * from magasins where lat != '0' && lng != '0' && dep = '$dep'", $connexion); $nb_magasins = mysql_num_rows($magasins); } $departements = mysql_query("select * from departements where code in(select distinct dep from magasins where lat != '0' && lng != '0') order by ordre ", $connexion); $nb_departements = mysql_num_rows($departements); $latcentre=45.96337; $lngcentre=2.538; $lezoom=6; if(isset($_GET['dep']) && $_GET['dep'] != ''){ $ledep=$_GET['dep']; $monseldep=mysql_query("select * from departements where code='$ledep' ",$connexion); if(mysql_num_rows($monseldep)){ $latcentre=mysql_result($monseldep,0,'lat'); $lngcentre=mysql_result($monseldep,0,'lng'); $lezoom=9; } } ?>