if ($total_results>0){
echo $total_results-1 ;
echo " ads founds within this search";
}else{
echo "Theres is no results within this search";
}
?>
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 atomik1_interpac.$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!="" && $var[13]=="Français" || $langue!="" && $var[13]=="Anglais"){
$i=$i+1;
if ($fois1!=1 && $page<2 || $fois1!=1 && $page==null){
if($categorie!='0'){
$rs=mysql_query("select * from atomik1_interpac.$idd where pc='Commerce' and categorie='$categorie' order by dist asc LIMIT 0, 2");
}else{
$commandeq = "SELECT * from atomik1_interpac.$idd where pc='Commerce' order by dist asc LIMIT 0,2";
$rs = mysql_query($commandeq);
}
//$commandeq = "SELECT * from atomik1_interpac.$idd where pc='Commerce' order by dist desc LIMIT 0, 2";
//$rs = mysql_query($commandeq);
while ($var=mysql_fetch_row($rs)) {
if ($var[2]=="Offre"){
$var[2]="Offer";
}
if ($var[2]=="Recherche"){
$var[2]="Searching";
}
$var[0]=Round($var[0],1);
if($var[12]=="particulier"){
echo"
";
}
if($var[12]=="particulierp"){
echo"
";
}
if($var[12]=="Commerce"){
echo"
";
}
if($var[11]!=''){?>
}else{?>
}
echo"
";
//339000/338000/337000
if ($var[2]=="Offre"){
$var[2]="Offer";
}
if ($var[2]=="Recherche"){
$var[2]="Searching";
}
if($var[12]=="particulier"){
echo"
$var[2] $var[3] |
Price:$var[10] $ |
Posted $var[9] |
Description: $var[4] |
";
}
if($var[12]=="particulierp"){
echo"
$var[2] private PLUS $var[3] |
Price:$var[10] $ |
Posted $var[9] |
|
Description: $var[4] |
";
}
if($var[12]=="Commerce"){
echo"
$var[2] Commercial $var[3] |
Price:$var[10] $ |
Posted $var[9] |
|
Description: $var[4] |
";
}
if($var[12]=="particulier"){
if($var[11]!=''){?>
Picture:  | };
}
if($var[12]=="particulierp"){
if($var[11]!=''){?>
|
Picture:  | };
}
if($var[12]=="Commerce"){
if($var[11]!=''){?>
|
Picture:  | };
}
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" Online: NO | ";
}else{?>
Online: YES |
Chat with this user |
}
echo"
";
if($var[12]=="particulier"){
echo"
See it all... |
City: $var[8] | ";
if($tri!='distance'){
echo"Distance: $var[0] km of $ville | ";
}else{
echo"Distance: $var[0] km of $ville | ";
}
echo"
";
}
if($var[12]=="particulierp"){
echo"
| See it all... |
City: $var[8] | ";
if($tri!='distance'){
echo"Distance: $var[0] km of $ville | ";
}else{
echo"Distance: $var[0] km of $ville | ";
}
echo"
| | ";
}
if($var[12]=="Commerce"){
echo"
| See it all... |
City: $var[8] | ";
if($tri!='distance'){
echo"Distance: $var[0] km of $ville | ";
}else{
echo"Distance: $var[0] km of $ville | ";
}
echo"
";
}
}
//************************************************************************
//********************************
if($fois1!=1){
$fois1=1;
if($categorie!='0'){
$rs1=mysql_query("select * from atomik1_interpac.$idd where pc='particulierp' and categorie='$categorie' order by date desc");
while ($var1=mysql_fetch_row($rs1)) {
$po++;
}
$rs=mysql_query("select * from atomik1_interpac.$idd where pc='particulierp' and categorie='$categorie' order by dist asc");
}else{
$commandeq = "SELECT * from atomik1_interpac.$idd where pc='particulierp' order by dist asc LIMIT 0,2";
$rs = mysql_query($commandeq);
}
if($rs){
while ($var=mysql_fetch_row($rs)) {
if ($var[2]=="Offre"){
$var[2]="Offer";
}
if ($var[2]=="Recherche"){
$var[2]="Searching";
}
$var[0]=Round($var[0],1);
if($var[12]=="particulierp"){
echo"
";
}
if($var[11]!=''){?>
}else{?>
}
echo"
";
//339000/338000/337000
if($var[12]=="particulier"){
echo"
$var[2] $var[3] |
Price:$var[10] $ |
Posted $var[9] |
Description: $var[4] |
";
}
if($var[12]=="particulierp"){
echo"
$var[2] private PLUS $var[3] |
Price:$var[10] $ |
Posted $var[9] |
|
Description: $var[4] |
";
}
if($var[12]=="Commerce"){
echo"
$var[2] Commercial $var[3] |
Price:$var[10] $ |
Posted $var[9] |
|
Description: $var[4] |
";
}
if($var[12]=="particulier"){
if($var[11]!=''){?>
Picture:  | };
}
if($var[12]=="particulierp"){
if($var[11]!=''){?>
|
Picture:  | };
}
if($var[12]=="Commerce"){
if($var[11]!=''){?>
|
Picture:  | };
}
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" Online: NO | ";
}else{?>
Online: YES |
Chat with this user |
}
echo"
";
if($var[12]=="particulier"){
echo"
See it all... |
City: $var[8] | ";
if($tri!='distance'){
echo"Distance: $var[0] km of $ville | ";
}else{
echo"Distance: $var[0] km of $ville | ";
}
echo"
";
}
if($var[12]=="particulierp"){
echo"
See it all... |
City: $var[8] | ";
if($tri!='distance'){
echo"Distance: $var[0] km of $ville | ";
}else{
echo"Distance: $var[0] km of $ville | ";
}
echo"
";
}
if($var[12]=="Commerce"){
echo"
See it all... |
City: $var[8] | ";
if($tri!='distance'){
echo"Distance: $var[0] km of $ville | ";
}else{
echo"Distance: $var[0] km of $ville | ";
}
echo"
";
}}
}
}
$rs = mysql_query($commande);}
//************************************************************
//************************************************************
//************************************************************
//************************************************************
//************************************************************
//************************************************************
if ($var[2]=="Offre"){
$var[2]="Offer";
}
if ($var[2]=="Recherche"){
$var[2]="Searching";
}
if($var[12]=="particulier"){
echo"
";
}
if($var[12]=="particulierp"){
echo"
";
}
if($var[12]=="Commerce"){
echo"
";
}
if($var[11]!=''){?>
}else{?>
}
echo"
";
//339000/338000/337000
if($var[12]=="particulier"){
echo"
$var[2] $var[3] |
Price:$var[10] $ |
Posted $var[9] |
Description: $var[4] |
";
}
if($var[12]=="particulierp"){
echo"
$var[2] $var[3] |
Price:$var[10] $ |
Posted $var[9] |
|
Description: $var[4] |
";
}
if($var[12]=="Commerce"){
echo"
$var[2] commercial $var[3] |
Price:$var[10] $ |
Posted $var[9] |
|
Description: $var[4] |
";
}
if($var[12]=="particulier"){
if($var[11]!=''){?>
Picture:  | };
}
if($var[12]=="particulierp"){
if($var[11]!=''){?>
|
Picture:  | };
}
if($var[12]=="Commerce"){
if($var[11]!=''){?>
|
Picture:  | };
}
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" Online: NO | ";
}
}else{?>
Online: YES |
Chat with this user |
}
echo"
";
if($var[12]=="particulier"){
echo"
See it all... |
City: $var[8] | ";
if($tri!='distance'){
echo"Distance: $var[0] km of $ville | ";
}else{
echo"Distance: $var[0] km of $ville | ";
}
echo"
";
}
if($var[12]=="particulierp"){
echo"
| See it all... |
City: $var[8] | ";
if($tri!='distance'){
echo"Distance: $var[0] km of $ville | ";
}else{
echo"Distance: $var[0] km of $ville | ";
}
echo"
| | ";
}
if($var[12]=="Commerce"){
echo"
| See it all... |
City: $var[8] | ";
if($tri!='distance'){
echo"Distance: $var[0] km of $ville | ";
}else{
echo"Distance: $var[0] km of $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)
{
?>
}
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 "
Pick a page ";
if($page > 1){
$prev = ($page - 1);
if(isset($_GET['langue1'])&&!isset($_GET['langue'])){
echo "Previous ";
}
if(isset($_GET['langue'])&&!isset($_GET['langue1'])){
echo "Previous ";
}
if(isset($_GET['langue1'])&&isset($_GET['langue'])){
echo "Previous ";
}
}
$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 "Next>>";
}
if(isset($_GET['langue'])&&!isset($_GET['langue1'])){
echo "Next>>";
}
if(isset($_GET['langue1'])&&isset($_GET['langue'])){
echo "Next>>";
}
}
echo " |
";
}
?>
}else{?>
$comm="drop table atomik1_interpac.$idd";
$rscomm=mysql_query($comm);
mysql_close($db);
}?>