if ($total_results>0){
echo $total_results-1 ;
echo " annonces trouvées dans cette recherche";
}else{
echo "Aucun résultat pour la recherche effectuée";
}
?>
if ($rs){
while ($var=mysql_fetch_row($rs)) {
$s1="";
$s2="";
$s3="";
$s4="";
$s5="";
$s6="";
if ($tri!='distance'){
if($nomusager!="" && isset($_SESSION['nomusager'])|| isset($_SESSION['codepostal'])){// && $categorie !='0'){
$rsd="select dist from $idd where ville='$var[8]' order by date desc";
$cmrs=mysql_query($rsd);
$varqq=mysql_fetch_row($cmrs);
$varqq[0]=Round($varqq[0],1);
}else{
echo "pp";
$varqq[0]="indéfini";
}
}
//if($categorie!='0'){
// $rsd=mysql_query("select annonce, date, prix, photo,nuInterpac from $nomusager where ville='$var[8]' and categorie='$var[1]' and nomannonce='$var[3]' and annonceur='$var[5]'");
//}else{
//$rsd=mysql_query("select annonce, date, prix, photo,nuInterpac from $nomusager where ville='$var[8]' and annonceur='$var[5]'");
//}
// $var1q=mysql_fetch_row($rsd);
if($recherche!=""){
//$s1=strpos(strtolower($var[3]),strtolower($recherche));
//$s2=strpos(strtolower($var[5]),strtolower($recherche));
//$s3=strpos(strtolower($var[4]),strtolower($recherche));
//$s4=strpos(strtolower($var[10]),strtolower($recherche));
//$s5=strpos(strtolower($var[8]),strtolower($recherche));
//$s6=strpos(strtolower($var[9]),strtolower($recherche));
}
//echo "---";
//echo $var[9];
//echo "---";
$date2=$var[9];
list($year, $month, $day) = split('[-]', $date2);
$ok=diff2jours($day, $month, $year);
if($ok<=$nbjour || $nbjour=="0"){
if(strlen($var[4]) >= 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($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){
echo"
";
}
if($var[11]!=''){?>
}else{?>
}
echo"
";
//339000/338000/337000
if($var[12]=="particulier" ){
echo"";?>
|
Prix: $ |
Parue le |
Description: $var[4] |
";
}
if($var[12]=="particulierp"){
echo"
$var[2] particulier PLUS $var[3] |
Prix:$var[10] $ |
Parue le $var[9] |
Description: $var[4] |
";
}
if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){
echo"
$var[2] commerciale $var[3] |
Prix:$var[10] $ |
Parue le $var[9] |
|
Description: $var[4] |
";
}
if($var[12]=="particulier" ){
if($var[11]!=''){?>
Photo:  | };
}
if($var[12]=="particulierp"){
if($var[11]!=''){?>
|
};
}
if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){
if($var[11]!=''){?>
|
};
}
echo"
|
";
$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" En ligne: NON | ";
}else{?>
En ligne: OUI |
Clavarder avec cet usager |
}
echo"
";
if($var[12]=="particulier"){
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]=="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"
|
";
}
}
//************************************************************************
//********************************
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[11]!=''){?>
}else{?>
}
echo"
";
//339000/338000/337000
if($var[12]=="particulier"){
echo"";?>
echo $var[2]; echo $var[3]?> |
Prix: echo $var[10]?> $ |
Parue le |
Description: $var[4] |
";
}
if($var[12]=="particulierp"){
echo"
$var[2] particulier PLUS $var[3] |
Prix:$var[10] $ |
Parue le $var[9] |
Description: $var[4] |
";
}
if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){
echo"
$var[2] commerciale $var[3] |
Prix:$var[10] $ |
Parue le $var[9] |
|
Description: $var[4] |
";
}
if($var[12]=="particulier"){
if($var[11]!=''){?>
Photo:  | };
}
if($var[12]=="particulierp"){
if($var[11]!=''){?>
|
Photo:  | };
}
if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){
if($var[11]!=''){?>
|
Photo:  | };
}
echo"
|
";
$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" En ligne: NON | ";
}else{?>
En ligne: OUI |
Clavarder avec cet usager |
}
echo"
";
if($var[12]=="particulier"){
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]=="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($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){
echo"
";
}
if($var[11]!=''){?>
}else{?>
}
echo"
";
//339000/338000/337000
if($var[12]=="particulier"){
echo"";?>
echo $var[2]; echo " "; echo $var[3]?> |
Prix: echo $var[10]?> $ |
Parue le |
Description: $var[4] |
";
}
if($var[12]=="particulierp"){
echo"
$var[2] $var[3] |
Prix:$var[10] $ |
Parue le $var[9] |
Description: $var[4] |
";
}
if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){
echo"
$var[2] commerciale $var[3] |
Prix:$var[10] $ |
Parue le $var[9] |
|
Description: $var[4] |
";
}
if($var[12]=="particulier"){
if($var[11]!=''){?>
};
}
if($var[12]=="particulierp"){
if($var[11]!=''){?>
|
};
}
if($var[12]=="Commerce" || $var[12]=="page" || $var[12]=="Page"){
if($var[11]!=''){?>
|
};
}
echo"
|
";
$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" En ligne: NON | ";
}
}else{?>
En ligne: OUI |
Clavarder avec cet usager |
}
echo"
";
if($var[12]=="particulier"){
?>
En savoir plus... |
Ville: echo $var[8]?> |
if($tri!='distance'){?>
Distance: echo $var[0]?> km de echo $ville?> |
}else{?>
Distance: echo $var[0]?> km de echo $ville?> |
}
echo"
";
}
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"
";
}
}
} }
}
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){
?>
}
if($i==5 ||$i==20||$i==35||$i==50||$i==65||$i==80||$i==95)
{
?>
$test= "";
}
if($i==10||$i==25||$i==40||$i==55||$i==70||$i==85||$i==100 ){
?>
}}}
?>
if(!isset($total_pages)||$total_pages<'1'){
$total_pages=1;
}
if($total_pages!=1){
echo "
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 " |
";
}
?>
}else{?>
$comm="drop table $idd";
$rscomm=mysql_query($comm);
mysql_close($db);
}
if(!isset($_SESSION['abc'])){
$_SESSION['abc'] = 1;
?>
}
if(isset($_SESSION['abc'])){
if(($_SESSION['abc'])!=1){
?>
}
}
?>