奈良のスポーツジム・スポーツクラブ特集

< ?php
include("connect.php");
?>

奈良・その他のフィットネス・スポーツジム・スポーツクラブ

< ?php

$db = connect();

$query = "SELECT * FROM sports_info WHERE place = '17';";

if(!($rs = mysql_query($query))) {
print $query;
print クエリー失敗;
}
while($row = mysql_fetch_array($rs)) {
$name = mb_convert_encoding($row['name'],'UTF-8', 'auto');
$shop_id = mb_convert_encoding($row['shop_id'],'UTF-8', 'auto');
$hp_url = mb_convert_encoding($row['hp_url'],'UTF-8', 'auto');
$sp_url = mb_convert_encoding($row['sp_url'],'UTF-8', 'auto');
$comment = mb_convert_encoding($row['comment'],'UTF-8', 'auto');
$sp_flag = mb_convert_encoding($row['sp_flag'],'UTF-8', 'auto');
if($row['sp_flag'] !== "1") {
$no_flag_data[] = array(
mb_convert_encoding($row['name'], "UTF8", "auto"),
mb_convert_encoding($row['shop_id'],"UTF8", "auto"),
mb_convert_encoding($row['hp_url'],"UTF8", "auto"),
mb_convert_encoding($row['sp_url'],"UTF8", "auto"),
mb_convert_encoding($row['comment'],"UTF8", "auto"),
$sp_flag
);
} else {
$flag_data[] = $shop_id;
}
}

//契約店舗
if($flag_data) {
foreach ($flag_data as $str) {
$query = "SELECT sports_detail.id,sports_detail.shop_id,name,address,tel,hp_url,sp_url,sports_info.comment FROM sports_detail INNER JOIN sports_info ON sports_detail.shop_id = sports_info.shop_id where sports_info.shop_id = " . $str . ";";

if(!($rs = mysql_query($query))) {
print $query;
print クエリー失敗;
}

$row = mysql_fetch_row($rs);
$id = mb_convert_encoding($row[0], "UTF8", "auto");
$shop_id = mb_convert_encoding($row[1], "UTF8", "auto");
$name = mb_convert_encoding($row[2], "UTF8", "auto");
$address = mb_convert_encoding($row[3], "UTF8", "auto");
$tel = mb_convert_encoding($row[4], "UTF8", "auto");
$hp_url = mb_convert_encoding($row[5], "UTF8", "auto");
$sp_url = mb_convert_encoding($row[6], "UTF8", "auto");
$comment = mb_convert_encoding($row[7], "UTF8", "auto");

//クーポンがあるかどうか
$query = "SELECT count(*) FROM sports_coupon WHERE shop_id = " . $shop_id . ";";

if(!($rs = mysql_query($query))) {
print $query;
print クエリー失敗;
}

$row = mysql_fetch_row($rs);

print "

“;
print “ “;
print “

“;

}
}
if($no_flag_data) {
foreach($no_flag_data as $str2) {

$name = $str2[0];
$shop_id = $str2[1];
$hp_url = $str2[2];
$sp_url = $str2[3];
$comment = $str2[4];

print “

“;
}
}
?>

“; print “ “; print “ “; print “ “; print “ “; } else { print “ ”; } print “ “; print “ “; print “” . $name . “ “; if($row[0] !== “0″) { print “

“; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ ” . $comment . “ TEL ： ” . $tel . “ 住所 ： “.$address . “ URL ： “.$sp_url.”web

“; print “ ” . $name; print “ “; print $comment . “