Chargement en cours...






"; }else{ echo"



"; } if (isset($_SESSION['nomusager'])){ $nomusager=$_SESSION['nomusager']; } if (isset($_SESSION['nomusager']) && $nomusager!="" || isset($_SESSION['codepostal'])){?>

Recherche d'annonces
Mot à rechercher:
Catégorie:      
Date de parution:
Trier par:        
Langage    Distance max.:
Type d'annonces:   
Liste de:         
  ='$minLat' and Longitude<'$maxLong' and Longitude>'$minLong' group by City order by City Asc"; $rsDist1=mysql_query($d2); if(!$rsDist1){ $vv=str_replace("'", " ",$ttr[8]); $d2="select * from Ville WHERE villeok='$vv' order by villeok Asc"; //Latitude <= '$maxLat' and Latitude >='$minLat' and Longitude<'$maxLong' and Longitude>'$minLong' group by City order by City Asc"; $rsDist1=mysql_query($d2); if(!$rsDist1){ $vv=str_replace("'", " ",$ttr[8]); $d2="select * from Ville WHERE NomVille='$ttr[8]' order by NomVille Asc"; //Latitude <= '$maxLat' and Latitude >='$minLat' and Longitude<'$maxLong' and Longitude>'$minLong' group by City order by City Asc"; $rsDist1=mysql_query($d2); }} $ttr[8]=str_replace("'", " ",$ttr[8]); while($varD=mysql_fetch_row($rsDist1)){ $dblLat1 = $Latitude * M_PI / 180; $dblLong1 = $Longitude * M_PI / 180; $dblLat2 = $varD[5] * M_PI / 180; $dblLong2 = $varD[6] * M_PI / 180; if ($dblLat1 != $dblLat2 || $dblLong1 != $dblLong2) { $dist = sin($dblLat1) * sin($dblLat2) + cos($dblLat1) * cos($dblLat2) * cos($dblLong2 - $dblLong1); $dist = $EARTH_RADIUS_MILES * (-1 * atan($dist / sqrt(1 - $dist * $dist)) + M_PI / 2); } else{ $dist=0; }; $dist4="Create table inter486_interpac.$idd (dist double, categorie text, type text, nomannonce text, annonce text, annonceur text, telephone varchar(10), email text, ville text, date date, prix text, photo text, pc text, langue text, province text, nuInterpac int(11))"; $rsd=mysql_query($dist4); if($rsd){ $rqw2="Create index Rapide on $idd (dist)"; $rew33=mysql_query($rqw2); }; $varD[1]=str_replace("'","",$varD[1]); if ($ttr) $ttr[4]=str_replace("'","", $ttr[4]); $ttr[3]=str_replace("'","", $ttr[3]); $date2=$ttr[9]; list($year, $month, $day) = split('[-/\]', $date2); $ok=diff2jours($day, $month, $year); if($ok<=$nbjour || $nbjour=="0"){ if($ttr[13]=="Fran&#36555;is"){ $ttr[13]="Français"; } if (substr($ttr[13],0,4)=="Fran" && $langue1=="francais"|| $ttr[13]=="Anglais" && $langue=="anglais" ) { if($dist<=$dista){ $ser="insert into $idd (dist, categorie, type, nomannonce, annonce, annonceur, telephone, email, ville, date, prix, photo, pc, langue, province, nuInterpac) VALUES ( '$dist', '$ttr[1]', '$ttr[2]','$ttr[3]','$ttr[4]','$ttr[5]','$ttr[6]','$ttr[7]','$ttr[8]','$ttr[9]','$ttr[10]','$ttr[11]','$ttr[12]','$ttr[13]','$ttr[14]', '$ttr[0]') "; $rsser=mysql_query($ser); if($rsser){ // echo $_SESSION['Ville']; } }} } } }} }}} $b=0; $cmmande = "SELECT * from $idd"; $ars = mysql_query($cmmande); if($ars){ while($vaw=mysql_fetch_row($ars)){ $b++; }} ?>
0){ echo $total_results-1 ; echo " annonces trouvées dans cette recherche"; }else{ echo "Aucun résultat pour la recherche effectuée"; } ?>

= 191){ $var[4]=substr($var[4],0,191); $var[4]=substr_replace($var[4], '...',187,190); } if($type!="" && $var[2]=="Offre" || $type1!="" && $var[2]=="Recherche" || $type!="" && $var[2]=="offre" || $type1!="" && $var[2]=="recherche"){ $var[0]=Round($var[0],1); //if($recherche!="" && $s1!==false || $recherche!="" && $s2!==false || $recherche!="" && $s3!==false || $recherche!="" && $s4!==false || $recherche!="" && $s5!==false || $recherche!="" && $s6!==false ||$recherche==""){ if($recherche=="" || $recherche!=""){ if($langue1!="" && substr($var[13],0,4)=="Fran" || $langue!="" && $var[13]=="Anglais"){ $i=$i+1; if ($fois1!=1 && $page<2 || $fois1!=1 && $page==null){ if($categorie!='0'){ $rs=mysql_query("select * from $idd where pc='Commerce' and categorie='$categorie' or pc='Page' and categorie='$categorie' or pc='page' and categorie='$categorie' order by dist asc LIMIT 0, 2"); }else{ $commandeq = "SELECT * from $idd where pc='Commerce' or pc='Page' or pc='page' order by dist asc LIMIT 0,2"; $rs = mysql_query($commandeq); } //$commandeq = "SELECT * from $idd where pc='Commerce' order by dist desc LIMIT 0, 2"; //$rs = mysql_query($commandeq); while ($var=mysql_fetch_row($rs)) { $var[0]=Round($var[0],1); if($var[12]=="particulier"){ echo"
"; } if($var[12]=="particulierp"){ echo" "; if($tri!='distance'){ echo""; }else{ echo""; } echo"
"; } if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){ echo" "; } if($var[12]=="particulier" ){ if($var[11]!=''){?>
"; } if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){ echo"
"; } if($var[11]!=''){?>
"; //339000/338000/337000 if($var[12]=="particulier" ){ echo"";?> "; } if($var[12]=="particulierp"){ echo"
Prix: $ Parue le
Description: $var[4]$var[2]
particulier PLUS
$var[3]
Prix:$var[10] $ Parue le $var[9]
Description: $var[4]$var[2]
commerciale
$var[3]
Prix:$var[10] $ Parue le $var[9]
Description: $var[4]
Photo:
"; $commande3 = "SELECT * FROM tmembres where NomUsager='$var[5]'"; $rs3 = mysql_query($commande3) ; $var2=mysql_fetch_row($rs3); $detail=$var[15]; $chat=$var[5]; $ville=$_SESSION['Ville']; if ($var2[9]=="non"||$var2[9]==""){ echo" "; }else{?>
En ligne: NONEn ligne: OUI Clavarder avec cet usager
"; if($var[12]=="particulier"){ echo" "; if($tri!='distance'){ echo""; }else{ echo""; } echo"
En savoir plus... Ville: $var[8]Distance: $var[0] km de $villeDistance: $var[0] km de $ville

"; } if($var[12]=="particulierp"){ echo"
En savoir plus... Ville: $var[8]Distance: $var[0] km de $villeDistance: $var[0] km de $ville

"; } if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){ echo" En savoir plus... Ville: $var[8]"; if($tri!='distance'){ echo"Distance: $var[0] km de $ville"; }else{ echo"Distance: $var[0] km de $ville"; } echo"
"; } } //************************************************************************ //******************************** if($fois1!=1){ $fois1=1; if($categorie!='0'){ $rs1=mysql_query("select * from $idd where pc='particulierp' and categorie='$categorie' order by date desc"); while ($var1=mysql_fetch_row($rs1)) { $po++; } $rs=mysql_query("select * from $idd where pc='particulierp' and categorie='$categorie' order by dist asc"); }else{ $commandeq = "SELECT * from $idd where pc='particulierp' order by dist asc LIMIT 0,2"; $rs = mysql_query($commandeq); } if($rs){ while ($var=mysql_fetch_row($rs)) { $var[0]=Round($var[0],1); if($var[12]=="particulierp"){ echo" "; } if($var[12]=="particulier"){ if($var[11]!=''){?>
"; } if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){ echo"
"; } if($var[11]!=''){?>
"; //339000/338000/337000 if($var[12]=="particulier"){ echo"";?> "; } if($var[12]=="particulierp"){ echo"
Prix: $ Parue le
Description: $var[4]$var[2]
particulier PLUS
$var[3]
Prix:$var[10] $ Parue le $var[9]
Description: $var[4]$var[2]
commerciale
$var[3]
Prix:$var[10] $ Parue le $var[9]
Description: $var[4]
Photo:
Photo:
Photo:
"; $commande3 = "SELECT * FROM tmembres where NomUsager='$var[5]'"; $rs3 = mysql_query($commande3) ; $var2=mysql_fetch_row($rs3); $detail=$var[15]; $chat=$var[5]; $ville=$_SESSION['Ville']; if ($var2[9]=="non"||$var2[9]==""){ echo" "; }else{?>
En ligne: NONEn ligne: OUI Clavarder avec cet usager
"; if($var[12]=="particulier"){ echo" "; if($tri!='distance'){ echo""; }else{ echo""; } echo"
En savoir plus... Ville: $var[8]Distance: $var[0] km de $villeDistance: $var[0] km de $ville

"; } if($var[12]=="particulierp"){ echo" En savoir plus... Ville: $var[8]"; if($tri!='distance'){ echo"Distance: $var[0] km de $ville"; }else{ echo"Distance: $var[0] km de $ville"; } echo"
"; } if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){ echo" En savoir plus... Ville: $var[8]"; if($tri!='distance'){ echo"Distance: $var[0] km de $ville"; }else{ echo"Distance: $var[0] km de $ville"; } echo"
"; }} } } $rs = mysql_query($commande);} //************************************************************ //************************************************************ //************************************************************ //************************************************************ //************************************************************ //************************************************************ if($var[12]=="particulier"){ echo"
"; } if($var[12]=="particulierp"){ echo" "; if($tri!='distance'){ echo""; }else{ echo""; } echo"
"; } if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){ echo" "; } if($var[12]=="particulier"){ if($var[11]!=''){?>
"; } if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){ echo"
"; } if($var[11]!=''){?>
"; //339000/338000/337000 if($var[12]=="particulier"){ echo"";?> "; } if($var[12]=="particulierp"){ echo"
Prix: $ Parue le
Description: $var[4]$var[2] $var[3] Prix:$var[10] $ Parue le $var[9]
Description: $var[4]$var[2] commerciale $var[3] Prix:$var[10] $ Parue le $var[9]
Description: $var[4]
"; $commande3 = "SELECT * FROM tmembres where NomUsager='$var[5]'"; $rs3 = mysql_query($commande3) ; $var2=mysql_fetch_row($rs3); $detail=$var[15]; $chat=$var[5]; $ville=$_SESSION['Ville']; if ($var2[9]=="non"||$var2[9]==""){ if($var[12]=="particulier"){ echo" "; } }else{?>
En ligne: NONEn ligne: OUI Clavarder avec cet usager
"; if($var[12]=="particulier"){ ?>
En savoir plus... Ville: Distance: km de Distance: km de

"; } if($var[12]=="particulierp"){ echo"
En savoir plus... Ville: $var[8]Distance: $var[0] km de $villeDistance: $var[0] km de $ville

"; } if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){ echo" En savoir plus... Ville: $var[8]"; if($tri!='distance'){ echo"Distance: $var[0] km de $ville"; }else{ echo"Distance: $var[0] km de $ville"; } echo"
"; } } } } } if($total_results>8){ if($total_results==$i||$i==15||$i==1||$i==45||$i==60||$i==75||$i==90 ){//|| $i==5 || $i==10 || $i==15 || $i==20|| $i==25|| $i==30|| $i==35|| $i==40|| $i==45|| $i==55){ ?>
Sondages payants



document.write(xy)"; } if($i==10||$i==25||$i==40||$i==55||$i==70||$i==85||$i==100 ){ ?>

Choisissez une page
"; if($page > 1){ $prev = ($page - 1); if(isset($_GET['langue1'])&&!isset($_GET['langue'])){ echo "Précédant "; } if(isset($_GET['langue'])&&!isset($_GET['langue1'])){ echo "Précédant "; } if(isset($_GET['langue1'])&&isset($_GET['langue'])){ echo "Précédant "; } } $fr=$page-5; $dd=5; if($fr<1){ $fr=1; } if($page==1){ $dd=9; } if($page==2){ $dd=8; } if($page==3){ $dd=7; } if($page==4){ $dd=6; } if($dd+$page>$total_pages){ $dd=$total_pages-$page; } for($i = $fr; $i <= $page+$dd; $i++){ if(($page) == $i){ echo "[$i] "; } else { if(isset($_GET['langue1'])&&!isset($_GET['langue'])){ echo "$i "; } if(isset($_GET['langue'])&&!isset($_GET['langue1'])){ echo "$i "; } if(isset($_GET['langue1'])&&isset($_GET['langue'])){ echo "$i "; } } } if($page < $total_pages){ $next = ($page + 1); if(isset($_GET['langue1'])&&!isset($_GET['langue'])){ echo "Suivant>>"; } if(isset($_GET['langue'])&&!isset($_GET['langue1'])){ echo "Suivant>>"; } if(isset($_GET['langue1'])&&isset($_GET['langue'])){ echo "Suivant>>"; } } echo "
"; } ?>






La rubrique est présentement vide. Veuillez réessayer plus tard

Toutes les rubriques sont présentement vides. Veuillez réessayer plus tard