";
$sorgu = mysql_query($sorgu);
while ($cek=mysql_fetch_array($sorgu)) {
$trid= $cek['ID'];
//echo $trid;
$sorgu_nl = mysql_query("select * from M1U4dxQdaH_posts where M1U4dxQdaH_posts.post_status ='publish' and ID='".$trid."' order by ID desc limit 5");
while ($ceknl=mysql_fetch_array($sorgu_nl)) {
if ($ceknl['post_status']!=='publish'){continue;}
$id = $ceknl['ID'];
$title = $ceknl['post_title'];
$desc = $ceknl['post_content'];
$guid = $ceknl['guid'];
$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
if ($cekmeta['meta_key']=='property_price') {
$price=doubleval($cekmeta['meta_value']);}
if ($cekmeta['meta_key']=='property_label_before') {
$pricepre=$cekmeta['meta_value'];}
}
$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
if ($cekmeta['meta_key']=='property_size') {
$size=$cekmeta['meta_value'];}
}
$sorgu_meta = mysql_query("select * from M1U4dxQdaH_term_relationships where object_id = '".$id."'");
while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
$termid=$cekmeta['term_taxonomy_id'];
$sorgu_meta2 = mysql_query("select * from M1U4dxQdaH_terms where term_id = '".$termid."'");
while ($cekmeta2=mysql_fetch_array($sorgu_meta2)) {
$sorgu_meta3 = mysql_query("select * from M1U4dxQdaH_term_taxonomy where term_id = '".$termid."'");
while ($cekmeta3=mysql_fetch_array($sorgu_meta3)) {
if ($cekmeta3['taxonomy']=='property_city') {
$location=$cekmeta2['name'];}
if ($cekmeta3['taxonomy']=='property_type') {
//$ptype=$cekmeta2['name'];
}
}
}
}
$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
if ($cekmeta['meta_key']=='property_rooms') {
$bedrooms=$cekmeta['meta_value'];}
}
$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
if ($cekmeta['meta_key']=='property_bathrooms') {
$bathrooms=$cekmeta['meta_value'];}
}
$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
if ($cekmeta['meta_key']=='mls') {
$ref=$cekmeta['meta_value'];}
}
$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
if ($cekmeta['meta_key']=='property_location') {
$map=$cekmeta['meta_value'];}
//$maplat=$cekmeta['houzez_geolocation_lat'];
//$maplong=$cekmeta['houzez_geolocation_long'];
}
$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
if ($cekmeta['meta_key']=='_thumbnail_id') {
$imagethumbid=$cekmeta['meta_value'];
$sorgu_thumb= mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$imagethumbid."'");
while ($cekthumb=mysql_fetch_array($sorgu_thumb)) {
if ($cekthumb['meta_key']=='_wp_attached_file') {
$imgthumb=$cekthumb['meta_value'];}
}
}
}
$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
if ($cekmeta['meta_key']=='property_images') {
$images=$cekmeta['meta_value'];}
}
}
$price=number_format($price,"0",".",".")." €";
echo '
';
$pricepre='';
}
?>
-
$limit) :
$x = 2; // akrif sayfadan önceki/sonraki sayfa gösterim sayisi
$lastP = ceil($satirsayisi/$limit);
if($pg > 1){
$onceki = $pg-1;
echo '
- « '; } else { ?>
- « 1'; else echo '
- 1 '; if($pg-$x > 2) { echo '
- ··· '; $i = $pg-$x; } else { $i = 2; } // +/- $x sayfalari yazdir for($i; $i<=$pg+$x; $i++) { if($i==$pg) echo '
- '.$i.' '; else echo '
- '.$i.' '; if($i==$lastP) break; } // "..." veya son sayfa if($pg+$x < $lastP-1) { echo '
- ··· '; echo '
- '.$lastP.' '; } elseif($pg+$x == $lastP-1) { echo '
- '.$lastP.' '; } if($pg < $lastP){ $sonraki = $pg+1; echo '
- » '; } else { ?>
- »