|
中国ゴルフ場クイック検索&予約
$city="上海市"; include_once("/home/shanghai/infiles/golf_search.inc"); $city="shanghai"; ?>
|
echo $title; ?>
// if(isset($ctgc)){ $qstr = "AND ctgc='$ctgc'"; }else{ $qstr=""; }
// $query = "SELECT * FROM $dbname WHERE ctg='$cid' AND ctgb ='$ctgb' $qstr ORDER BY sid ASC,id ASC";
$query="SELECT DISTINCT ON (c.cid) gl.id,gl.sid,gl.shopanchor,gl.title,gl.bannerlink,gl.img,gl.imgl,gl.description,gl.fee,gl.add,gl.lng,gl.tel,p.wd_v_price,p.hd_v_price,p.wd_t_price,p.hd_t_price FROM shcontent as gl,golf_content as c,golf_price_view as p WHERE c.cid=gl.shopanchor AND c.cid=p.cid $sort";
$rtn = pg_exec($query);
$n=pg_num_rows($rtn);
$shopname="dummy";
for($i=0; $i<$n;$i++){
$row = pg_fetch_array($rtn,$i);
if($row['sid']){ $sid=$row['sid']; }else{ $sid=$row['id']; }
if($row['shopanchor']){ $shopanchor = $row['shopanchor']; }else{ $shopanchor=$row['id']; }
?>
echo $row['title']; ?>
if($row['img']){
if(file_exists("./images/".$row['img'])){
?>
if($row['imgl']){ ?> } ?>
if($row['imgl']){ ?> } ?>
}
}elseif(file_exists("/home/shanghai/".$r.".explore.ne.jp/".$cid."/images/".$row['id'].".jpg")){ ?>
}
echo nl2br($row['description']);
?>
echo $row['title']; ?>詳細>>>
if(trim($row['fee'])){ echo " FEE:".$row['fee']." "; } ?>
if($row['add']){ echo " ADD:".$row['add']; } ?> if($row['lat'] && $row['lng']){ ?> 【 地図】 } ?>
if(trim($row['tel'])){ echo " TEL:".$row['tel']." "; } ?>
//予約データの表示
if($row['wd_t_price'] || $row['hd_t_price']){
if($tuka=="jp"){
if(!$row['hd_v_price']){ $hd_v_price ="予約不可";
}else{ $hd_v_price = exchange($row['hd_v_price'])."円/人"; }
if(!$row['wd_v_price']){ $wd_v_price ="予約不可";
}else{ $wd_v_price = exchange($row['wd_v_price'])."円/人"; }
if(!$row['hd_t_price']){ $hd_t_price ="予約不可";
}else{ $hd_t_price = exchange($row['hd_t_price'])."円/人"; }
if(!$row['wd_t_price']){ $wd_t_price ="予約不可";
}else{ $wd_t_price = exchange($row['wd_t_price'])."円/人"; }
}else{
if(!$row['wd_v_price']){ $wd_v_price ="予約不可";
}else{ $wd_v_price = $row['wd_v_price']."元/人"; }
if(!$row['wd_t_price']){ $wd_t_price ="予約不可";
}else{ $wd_t_price = $row['wd_t_price']."元/人"; }
if(!$row['hd_t_price']){ $hd_t_price ="予約不可";
}else{ $hd_t_price = $row['hd_t_price']."元/人"; }
if(!$row['hd_v_price']){ $hd_v_price ="予約不可";
}else{ $hd_v_price = $row['hd_v_price']."元/人"; }
}
if($wd_t_price !="予約不可" || $hd_t_price !="予約不可"){
?>
| ビジター料金 | 本サイト特別価格 |
| 平日 | echo $wd_v_price; ?> | echo $wd_t_price; ?> |
| 休日 | echo $hd_v_price; ?> | echo $hd_t_price; ?> |
}
}
?>
|
|
}
?>
| include("/home/shanghai/infiles/tb.inc"); ?> echo $feature; ?> |
|
| include("/home/shanghai/infiles/contentboard.inc"); ?> |
|
|
本ページをわざわざ印刷する必要などありません!。 本ページの内容を携帯電話でご覧いただけます。詳しくはこちら
|
|
|