echo ""; if ($region < 22) { echo "

Plan de site ".$table_region [$region]."

 
 
Les d�partements de la r�gion ".$table_region[$region]."
"; } echo "
Les principales villes de ".$table_region[$region]."
    "; $query = "select pa.idurlville, pv.urlville, pv.ville, count(*) as nb from pa_annonces as pa, pa_villes as pv where pa.etat = '1' and pa.region = '$region' and pv.region = '$region' and pv.id = pa.idville group by pa.idurlville order by nb desc limit 0, 150"; $res= mysql_query($query); while ($i=mysql_fetch_array($res)) { $idurlville = $i['idurlville']; $urlville = $i['urlville']; $ville = stripSlashes($i['ville']); echo "
  • ".randkeywords ()." $ville
  • "; } echo "
"; echo ""; $query="select * from pa_categories "; $result=mysql_query($query); $nbc = mysql_num_rows ($result); $c=0; while ($z=mysql_fetch_array($result)) { $idc = $z['id']; $nc = stripSlashes($z['lien']); $uc = $z['url']; $pagerw = makeurl8 ($region, 0, $uc, $idc); if (!($c%2)) echo ""; echo ""; if ($c%2) echo ""; $c++; } echo "
Les cat�gories de la r�gion ".$table_region[$region]."
 
";