 |
|
ผมเขียนให้โชวข้อมูลบ้านทีละ 3 หลัง มันก็โชว์นะ แต่ปุ่ม เดินหน้า ถอยหลัง มันไม่โชว์อ่ะครับ รบกวนหน
//Code
<?
include_once("connect.php");
$get_id = "SELECT distinct a.listingsdb_id
FROM bkkapart_en_listingsdbelements a, bkkapart_classlistingsdb b
WHERE a.listingsdbelements_field_name = 'city'
and a.listingsdb_id = b.listingsdb_id
and b.class_id = $select_type
ORDER BY a.listingsdb_id ";
// Show Page ---
//---
$Per_Page = 3;
if ( !$Page )
$Page = 1;
$Prev_Page = $Page - 1;
$Next_Page = $Page + 1;
$Page_start = ( $Per_Page * $Page ) - $Per_Page;
$get_id .= " LIMIT $Page_start, $Per_Page";
$db_query1 = mysql_db_query($dbname,$get_id);
$Num_Rows = mysql_num_rows($db_query1);
if ( $Num_Rows <= $Per_Page )
$Num_Pages = 1;
else if ( ( $Num_Rows % $Per_Page ) == 0 )
$Num_Pages = ( $Num_Rows / $Per_Page );
else
$Num_Pages = ( $Num_Rows / $Per_Page ) + 1;
$Num_Pages = ( int ) $Num_Pages;
if ( ( $Page > $Num_Pages ) || ( $Page < 0 ) )
print "Number $Page more than $Num_Pages";
while($result = mysql_fetch_array($db_query1))
{
$sql = "SELECT DISTINCT a.listingsdb_id,(SELECT
b.listingsdbelements_field_value
FROM bkkapart_en_listingsdbelements b
WHERE b.listingsdbelements_field_name = 'city'
AND b.listingsdb_id = a.listingsdb_id ) AS fcity,
(SELECT b.listingsdbelements_field_value
FROM bkkapart_en_listingsdbelements b
WHERE b.listingsdbelements_field_name = 'Area'
AND b.listingsdb_id = a.listingsdb_id ) AS fArea,
(SELECT b.listingsdbelements_field_value
FROM bkkapart_en_listingsdbelements b
WHERE b.listingsdbelements_field_name = 'beds'
AND b.listingsdb_id = a.listingsdb_id ) AS fbeds,
(SELECT b.listingsdbelements_field_value
FROM bkkapart_en_listingsdbelements b
WHERE b.listingsdbelements_field_name = 'price'
AND b.listingsdb_id = a.listingsdb_id ) AS fprice,
(SELECT b.listingsdbelements_field_value
FROM bkkapart_en_listingsdbelements b
WHERE b.listingsdbelements_field_name = 'home_features'
AND b.listingsdb_id = a.listingsdb_id) AS ffeatures,
c.listingsdb_title AS ftitle,
d.listingsimages_thumb_file_name AS fpicture
FROM bkkapart_en_listingsdbelements a, bkkapart_en_listingsdb c, bkkapart_en_listingsimages d
WHERE a.listingsdb_id = $result[listingsdb_id]
AND a.listingsdb_id = c.listingsdb_id
AND c.listingsdb_id = d.listingsdb_id
AND d.listingsimages_rank = '1' ";
//---
$db_query2 = mysql_db_query($dbname,$sql);
while($result1 = mysql_fetch_array($db_query2))
{
$title = $result1[ftitle];
$city = $result1[fcity];
$area = $result1[fArea];
$beds = $result1[fbeds];
$price = $result1[fprice];
$H_features = $result1[ffeatures];
$picture = $result1[fpicture];
echo"<br><br>";
echo"<div style='padding: 1px;'>
<div style='float:left; width: 370px; height:220px; border: 1px solid;'>
<div style='float:left; width: 369px; height:20px; border: 1px solid;'><font size = 2><b>$title</b></font></div>
<div style='float:left; width: 110px; height:180px; border: 0px solid;'>
<div style='float:left; margin-left:2px; margin-right:2px; margin-top:2px; margin-bottom:2px; width: 104px; height:176px; border: 0px solid;'><font size = 2><a href='show_detail.php?listingsdb_id=$result[listingsdb_id]'><img src = 'images/listing_photos/$picture' border= 0></a> </font>
</div>
</div>
<div style='float:left; width: 253px; height:180px; border: 0px solid;'>
<div style='float:left; width: 253px; height: 20px;'><font size = 2><b>city</b> : $city</font></div>
<div style='float:left; width: 253px; height: 20px;'><font size = 2><b>area</b> : $area</font></div>
<div style='float:left; width: 253px; height: 20px;'><font size = 2><b>price</b> : $price Thb.</font></div>
<div style='float:left; width: 253px; height: 120px;'><font size = 2><b>features</b> : <br>$H_features</font></div>
</div>
<div style='float:left; width: 370px; height:20px; border: 0px solid;'>
<div style='float:right; width: 50px; height: 20px;'><font size = 2><a href='show_detail.php?listingsdb_id=$result[listingsdb_id]'><b>Detail</b></a></font></div>
</div>
</div>
</div><br><br><br><br><br><br><br><br><br><br><br><br>";
}
}
echo "<br>";
echo "<br>";
?>
<div align="left">
<?
/* Prev page*/
if ( $Prev_Page )
echo "<a href=\"$PHP_SELF?Page=$Prev_Page\"><< </a>";
/* number */
for ( $i=1; $i<=$Num_Pages; $i++ )
{
if ( $i != $Page )
echo "[<a href=\"$PHP_SELF?Page=$i\">$i</a>]";
else
echo " <b>$i</b> ";
}
/* Next page*/
if ( $Page != $Num_Pages )
echo "<a href=\"$PHP_SELF?Page=$Next_Page\"> >></a>";
?>
</div>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2 มี.ค. 2551 16:00:30 |
By :
ช่วยหน่อย |
View :
1247 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
