質問編集履歴

3

誤記

2017/03/31 04:22

投稿

igaiga
igaiga

スコア144

test CHANGED
File without changes
test CHANGED
@@ -70,9 +70,9 @@
70
70
 
71
71
  ```
72
72
 
73
- $areainfo_lat = "35.65821";
73
+ $areainfo_lat = "35.6746700";
74
74
 
75
- $areainfo_lnt = "139.777162";
75
+ $areainfo_lnt = "139.7885380";
76
76
 
77
77
  $result = $wpdb->get_results("
78
78
 
@@ -128,4 +128,4 @@
128
128
 
129
129
  上記の出力結果はこんな感じです。
130
130
 
131
- 35.6746700139.7885380Array ( [0] => stdClass Object ( [post_title] => ソフィアタワー勝どき [id] => 562 [_lat] => 35.6584463 [_lnt] => 139.7735894 [googlemap] => a:3:{s:7:"address";s:41:"東京都中央区勝どき3丁目12-12";s:3:"lat";s:10:"35.6584463";s:3:"lng";s:11:"139.7735894";} [distance] => 2.2534462617295463 ) [1] => stdClass Object ( [post_title] => クレストレジデンス [id] => 561 [_lat] => 35.6571881 [_lnt] => 139.7719590 [googlemap] => a:3:{s:7:"address";s:41:"東京都中央区勝どき5丁目5-14 ";s:3:"lat";s:10:"35.6571881";s:3:"lng";s:18:"139.77195900000004";} [distance] => 2.453954933727737 ) )
131
+ Array ( [0] => stdClass Object ( [post_title] => ソフィアタワー勝どき [id] => 562 [_lat] => 35.6584463 [_lnt] => 139.7735894 [googlemap] => a:3:{s:7:"address";s:41:"東京都中央区勝どき3丁目12-12";s:3:"lat";s:10:"35.6584463";s:3:"lng";s:11:"139.7735894";} [distance] => 2.2534462617295463 ) [1] => stdClass Object ( [post_title] => クレストレジデンス [id] => 561 [_lat] => 35.6571881 [_lnt] => 139.7719590 [googlemap] => a:3:{s:7:"address";s:41:"東京都中央区勝どき5丁目5-14 ";s:3:"lat";s:10:"35.6571881";s:3:"lng";s:18:"139.77195900000004";} [distance] => 2.453954933727737 ) )

2

追記

2017/03/31 04:22

投稿

igaiga
igaiga

スコア144

test CHANGED
File without changes
test CHANGED
@@ -66,7 +66,7 @@
66
66
 
67
67
 
68
68
 
69
- ###試したSQL文:追記版()
69
+ ###試したSQL文:追記版
70
70
 
71
71
  ```
72
72
 
@@ -125,3 +125,7 @@
125
125
  ");
126
126
 
127
127
  ```
128
+
129
+ 上記の出力結果はこんな感じです。
130
+
131
+ 35.6746700139.7885380Array ( [0] => stdClass Object ( [post_title] => ソフィアタワー勝どき [id] => 562 [_lat] => 35.6584463 [_lnt] => 139.7735894 [googlemap] => a:3:{s:7:"address";s:41:"東京都中央区勝どき3丁目12-12";s:3:"lat";s:10:"35.6584463";s:3:"lng";s:11:"139.7735894";} [distance] => 2.2534462617295463 ) [1] => stdClass Object ( [post_title] => クレストレジデンス [id] => 561 [_lat] => 35.6571881 [_lnt] => 139.7719590 [googlemap] => a:3:{s:7:"address";s:41:"東京都中央区勝どき5丁目5-14 ";s:3:"lat";s:10:"35.6571881";s:3:"lng";s:18:"139.77195900000004";} [distance] => 2.453954933727737 ) )

1

変更

2017/03/31 03:35

投稿

igaiga
igaiga

スコア144

test CHANGED
File without changes
test CHANGED
@@ -66,7 +66,7 @@
66
66
 
67
67
 
68
68
 
69
- ###試したSQL文
69
+ ###試したSQL文:追記版()
70
70
 
71
71
  ```
72
72
 
@@ -82,13 +82,13 @@
82
82
 
83
83
  COS(RADIANS($areainfo_lat))
84
84
 
85
- * COS(RADIANS(_lat))
85
+ * COS(RADIANS(m1.meta_value))
86
86
 
87
- * COS(RADIANS(_lng) - RADIANS($areainfo_lnt))
87
+ * COS(RADIANS(m2.meta_value) - RADIANS($areainfo_lnt))
88
88
 
89
89
  + SIN(RADIANS($areainfo_lat))
90
90
 
91
- * SIN(RADIANS(_lat))
91
+ * SIN(RADIANS(m1.meta_value))
92
92
 
93
93
  )) AS distance
94
94
 
@@ -116,7 +116,7 @@
116
116
 
117
117
  AND m3.meta_key = 'googlemap'
118
118
 
119
- HAVING distance <= 5.0
119
+ HAVING distance
120
120
 
121
121
  ORDER BY distance
122
122