\n"; $shop_tmp = mysql_query($str_sql) or die(mysql_error()); $str_sql = "select * from pref where code = " .$_GET["code"]; $pref_tmp = mysql_query($str_sql) or die(mysql_error()); $pref_row = mysql_fetch_assoc($pref_tmp); if(mysql_num_rows($shop_tmp)) { print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; while($shop_row = mysql_fetch_array($shop_tmp)) { print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } print "

店舗名	住所	電話番号	MAP
"; if($shop_row["URL"] != null && $shop_row["URL"] != "") { print "" .$shop_row["SN"]. ""; } else { print $shop_row["SN"]; } print "	" .$pref_row["name"].$shop_row["CT"].$shop_row["SA"]. "	" .$shop_row["ST"]. "	"; if(!empty($shop_row["COR"])) { print ""; } print "

\n"; } else { } ?>