質問編集履歴
3
コード修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -56,7 +56,7 @@
|
|
56
56
|
|
57
57
|
if($db_budget) $sql .= ' AND find_in_set(budget=:budget, :budget)';
|
58
58
|
|
59
|
-
//if($db_budget) $sql .= ' AND find_in_set("501万円〜1000万円",
|
59
|
+
//if($db_budget) $sql .= ' AND find_in_set("501万円〜1000万円", budget)';だと検索できる
|
60
60
|
|
61
61
|
|
62
62
|
|
2
コード追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -56,6 +56,8 @@
|
|
56
56
|
|
57
57
|
if($db_budget) $sql .= ' AND find_in_set(budget=:budget, :budget)';
|
58
58
|
|
59
|
+
//if($db_budget) $sql .= ' AND find_in_set("501万円〜1000万円", :budget)';だと検索できる
|
60
|
+
|
59
61
|
|
60
62
|
|
61
63
|
//都道府県の検索条件(あいまい検索)
|
1
if\(\$db_budget\) \$sql \.= ' AND find_in_set\(budget=:budget, :budget\)'; 追加修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -54,7 +54,7 @@
|
|
54
54
|
|
55
55
|
//budgetの検索条件
|
56
56
|
|
57
|
-
if($db_budget) $sql .= ' AND budget
|
57
|
+
if($db_budget) $sql .= ' AND find_in_set(budget=:budget, :budget)';
|
58
58
|
|
59
59
|
|
60
60
|
|