回答編集履歴
3
改行およびクエリ修正
answer
CHANGED
|
@@ -1,8 +1,5 @@
|
|
|
1
1
|
```
|
|
2
|
-
$sql = "
|
|
2
|
+
$sql = "SELECT user_id,user_name,address,pass FROM user_data WHERE user_id='" . $u_id . "' GROUP BY " . $PASS;
|
|
3
|
-
from user_data
|
|
4
|
-
WHERE user_id='" . $u_id .
|
|
5
|
-
"' GROUP BY " . $PASS;
|
|
6
3
|
```
|
|
7
4
|
|
|
8
5
|
で文字列を連結するといかがでしょうか？
|
2
クォートの抜けを記述
answer
CHANGED
|
@@ -1,8 +1,8 @@
|
|
|
1
1
|
```
|
|
2
2
|
$sql = "select user_id,user_name,address,pass
|
|
3
3
|
from user_data
|
|
4
|
-
WHERE user_id=" . $u_id .
|
|
4
|
+
WHERE user_id='" . $u_id .
|
|
5
|
-
" GROUP BY " . $PASS;
|
|
5
|
+
"' GROUP BY " . $PASS;
|
|
6
6
|
```
|
|
7
7
|
|
|
8
8
|
で文字列を連結するといかがでしょうか？
|
1
GROUP BY句のミスを修正
answer
CHANGED
|
@@ -2,7 +2,7 @@
|
|
|
2
2
|
$sql = "select user_id,user_name,address,pass
|
|
3
3
|
from user_data
|
|
4
4
|
WHERE user_id=" . $u_id .
|
|
5
|
-
"GROUP BY
|
|
5
|
+
" GROUP BY " . $PASS;
|
|
6
6
|
```
|
|
7
7
|
|
|
8
8
|
で文字列を連結するといかがでしょうか？
|