include "header.php"; ?> |
include "menu.php"; ?>
|
|
$spr="select * from banner_slide order by id desc limit 0,1";
$repr=mysql_query($spr) or die("ERROR $spr บรรทัด225");
$rpr=mysql_fetch_row($repr);
?>

$snpr="select * from banner_slide";
$renpr=mysql_query($snpr) or die("ERROR $spr บรรทัด225");
$npr = mysql_num_rows($renpr);
$limit = $npr+1;
$spr1="select * from banner_slide order by id desc limit 1,$limit";
$repr1=mysql_query($spr1) or die("ERROR $spr1 บรรทัด225");
while($rpr1=mysql_fetch_row($repr1)){
?>

} ?>
|
|
|
|
 |
$strSQL="SELECT car_post.id, car_post.car_post, car_post.car_years, car_post.car_price_type, car_post.car_price, ";
$strSQL.="car_brand.brand_name, car_model.model_name, car_s_pic_post.car_s_picshow, member_shop.shop_name, ";
$strSQL.="car_post.car_m_id, car_post.car_status, car_post_sticky.id FROM car_post ";
$strSQL.="INNER JOIN car_brand ON car_post.car_brand = car_brand.id ";
$strSQL.="INNER JOIN car_model ON car_post.car_model = car_model.id ";
$strSQL.="INNER JOIN car_s_pic_post ON car_post.id = car_s_pic_post.car_post_id ";
$strSQL.="INNER JOIN car_post_sticky ON car_post.id = car_post_sticky.car_post_id ";
$strSQL.="INNER JOIN member_shop ON car_post.car_m_id = member_shop.member_id ";
$strSQL.="ORDER BY car_post.car_edit_date DESC LIMIT 0,16";
$objQuery = mysql_query($strSQL) or die("ERROR $strSQL บรรทัด 162-170");
echo"";
$intRows= 0;
while($objResult = mysql_fetch_row($objQuery)){
$urltpost=rewrite($objResult[1]);
$urltent=rewrite($objResult[8]);
echo "";
$intRows++;
?>
|
echo substr("$objResult[2]", -2); ?> |
|
|
if($objResult[10]==1){
echo "ขายแล้ว";
}else if($objResult[10]==0){
if($objResult[3]==1){
echo "ราคา ไม่ระบุ";
}else if($objResult[3]==2){
$car_p_number=$objResult[4];
$car_p_price= number_format($car_p_number);
echo "ราคา $car_p_price บาท";
}
}
?>
|
|
|
|
echo" | ";
if(($intRows)%4==0)
{
echo" ";
}
}
echo" ";
?> |
|
|
$strSQL="SELECT package_detail.introduced, member_shop.member_id, member_shop.shop_name, ";
$strSQL.="member.actived FROM `package_detail` ";
$strSQL.="INNER JOIN member_shop ON package_detail.package_id=member_shop.package_id ";
$strSQL.="INNER JOIN member ON member_shop.member_id=member.id ";
$strSQL.="WHERE package_detail.introduced='1' AND member.actived='1' ORDER BY member_shop.member_id ASC";
/*$strSQL1="SELECT category.*, sub_category.sub_cate_name FROM category ";
$strSQL1.="INNER JOIN sub_category ON category.id=sub_category.cate_id";*/
$objQuery = mysql_query($strSQL) or die("ERROR $strSQ1 บรรทัด 240-248");
echo"";
$intRows= 0;
while($objResult = mysql_fetch_row($objQuery))
{
$url=rewrite($objResult[2]);
echo "";
$intRows++;
?>
echo" | ";
if(($intRows)%5==0)
{
echo" ";
}
}
echo" ";
?>
|
|
|
$strSQL="SELECT car_post.id, car_post.car_post, car_post.car_years, car_post.car_price_type, car_post.car_price, ";
$strSQL.="car_brand.brand_name, car_model.model_name, car_s_pic_post.car_s_picshow, member_shop.shop_name, ";
$strSQL.="car_post.car_m_id, car_post.car_status FROM car_post ";
$strSQL.="INNER JOIN car_brand ON car_post.car_brand = car_brand.id ";
$strSQL.="INNER JOIN car_model ON car_post.car_model = car_model.id ";
$strSQL.="INNER JOIN car_s_pic_post ON car_post.id = car_s_pic_post.car_post_id ";
$strSQL.="INNER JOIN member_shop ON car_post.car_m_id = member_shop.member_id ";
$strSQL.="ORDER BY car_post.car_edit_date DESC LIMIT 0,16";
$objQuery = mysql_query($strSQL) or die("ERROR $strSQL บรรทัด 162-170");
echo"";
$intRows= 0;
while($objResult = mysql_fetch_row($objQuery)){
$urltpost=rewrite($objResult[1]);
$urltent=rewrite($objResult[8]);
echo "";
$intRows++;
?>
|
echo substr("$objResult[2]", -2); ?> |
|
|
if($objResult[10]==1){
echo "ขายแล้ว";
}else if($objResult[10]==0){
if($objResult[3]==1){
echo "ราคา ไม่ระบุ";
}else if($objResult[3]==2){
$car_p_number=$objResult[4];
$car_p_price= number_format($car_p_number);
echo "ราคา $car_p_price บาท";
}
}
?>
|
|
|
|
echo" | ";
if(($intRows)%4==0)
{
echo" ";
}
}
echo" ";
?> |
|
$sads5="SELECT * FROM `ads_a5`";
$reads5=mysql_query($sads5) or die("Error $sads5");
while($rads5=mysql_fetch_row($reads5)){
?>
|
} ?>
|
|
$strSQL2="SELECT car_post.id, car_s_pic_post.car_s_picshow, car_post.car_post, member.name, ";
$strSQL2.="member.tel, province.PROVINCE_NAME, car_post.car_post_date, car_post.car_price_type, ";
$strSQL2.="car_post.car_price, car_post.car_view, car_post.car_status FROM car_post ";
$strSQL2.="INNER JOIN car_s_pic_post ON car_post.id = car_s_pic_post.car_post_id ";
$strSQL2.="INNER JOIN member ON car_post.car_m_id = member.id ";
$strSQL2.="INNER JOIN province ON member.province_id = province.PROVINCE_ID ";
$strSQL2.="WHERE car_post.car_m_type=1 ORDER BY car_post.car_edit_date DESC LIMIT 0,10";
$objQuery2 = mysql_query($strSQL2) or die("ERROR $strSQL2 บรรทัด 380-386");
while($objResult2 = mysql_fetch_row($objQuery2)){
$urlpost=rewrite($objResult2[2]);
?>
|
|
ติดต่อ : โทร.
$carpostDate = $objResult2[6];
echo DateThai($carpostDate);
?>
|
|
if($objResult2[10]==1){
echo "ขายแล้ว";
}else if($objResult2[10]==0){
if($objResult2[7]==1){
echo "ราคา ไม่ระบุ";
}else if($objResult2[7]==2){
$car_p_number=$objResult2[8];
$car_p_price= number_format($car_p_number);
echo "ราคา $car_p_price บาท";
}
}
?>
|
|
เข้าชม ครั้ง |
|
|
|
} ?>
|
|
|
$sads3="SELECT * FROM `ads_a3`";
$reads3=mysql_query($sads3) or die("Error $sads3");
echo"";
$intRows= 0;
while($rads3=mysql_fetch_row($reads3))
{
echo "";
$intRows++;
?>
echo" | ";
if(($intRows)%6==0)
{
echo" ";
}
}
echo" ";
?> |
|
รูป |
ประเภท |
รายละเอียด |
ราคา |
|
$strSQL="SELECT classified_post_img.picshow, classified_type.type, classified_post.id, classified_post.type, classified_post.post_title, ";
$strSQL.="classified_post_contact.name, classified_post_contact.tel, classified_post_contact.province_id, province.PROVINCE_NAME, ";
$strSQL.="classified_post.post_date, classified_post.post_price_type, classified_post.post_price, classified_post.post_view ";
$strSQL.="FROM `classified_post` ";
$strSQL.="INNER JOIN classified_post_img ON classified_post.id=classified_post_img.post_id ";
$strSQL.="INNER JOIN classified_type ON classified_post.post_type=classified_type.id ";
$strSQL.="INNER JOIN classified_post_contact ON classified_post.id=classified_post_contact.post_id ";
$strSQL.="INNER JOIN province ON classified_post_contact.province_id=province.PROVINCE_ID ";
$strSQL.="INNER JOIN category ON classified_post.cate_id=category.id ";
$strSQL.="INNER JOIN sub_category ON classified_post.sub_cate_id=sub_category.id ";
$strSQL.="ORDER BY classified_post.post_update DESC LIMIT 0, 10";
$objQuery=mysql_query($strSQL);
$i=0;
while($objResult=mysql_fetch_row($objQuery)){
$posturl=rewrite($objResult[4]);
$postscate=rewrite($objResult[11]);
$i++;
if($i%2==0)
{
$bgjob="#EAEAEA";
}
else
{
$bgjob="#FFFFFF";
}
?>
|
|
|
ติดต่อ :
โทร.
จ.
$postDate = $objResult[9];
echo DateThai($postDate);
?>
|
|
if($objResult[10]==1){
echo "ราคา ไม่ระบุ";
}else if($objResult[10]==2){
$p_number=$objResult[11];
$p_price= number_format($p_number);
echo "ราคา $p_price บาท";
}
?>
|
|
เข้าชม
ครั้ง |
|
if($objResult[3]!=1){?>
} ?> |
|
|
|
} ?>
|
|
|
|
|
include "footer.php"; ?> |
|