回答編集履歴
4
文章変更
answer
CHANGED
|
@@ -12,4 +12,15 @@
|
|
|
12
12
|
WHERE user_id='$u_id'
|
|
13
13
|
GROUP BY pass
|
|
14
14
|
";
|
|
15
|
+
```
|
|
16
|
+
質問者さんはGROUP BYに対し、変数を入れようとしてるので
|
|
17
|
+
該当passを持つグループだけ抽出とかしたいのかな？
|
|
18
|
+
なら、GROUP BYでなく、WHEREに条件追加ですよ。
|
|
19
|
+
```PHP
|
|
20
|
+
$sql = "select user_id,user_name,address,pass
|
|
21
|
+
from user_data
|
|
22
|
+
WHERE user_id='$u_id'
|
|
23
|
+
AND pass='$pass'
|
|
24
|
+
GROUP BY pass
|
|
25
|
+
";
|
|
15
26
|
```
|
3
構文のミスを訂正
answer
CHANGED
|
@@ -10,6 +10,6 @@
|
|
|
10
10
|
$sql = "select user_id,user_name,address,pass
|
|
11
11
|
from user_data
|
|
12
12
|
WHERE user_id='$u_id'
|
|
13
|
-
GROUP BY pass
|
|
13
|
+
GROUP BY pass
|
|
14
14
|
";
|
|
15
15
|
```
|
2
不適切箇所の削除
answer
CHANGED
|
@@ -12,5 +12,4 @@
|
|
|
12
12
|
WHERE user_id='$u_id'
|
|
13
13
|
GROUP BY pass='$PASS'
|
|
14
14
|
";
|
|
15
|
-
```
|
|
15
|
+
```
|
|
16
|
-
若しくは文字列連結 ”user_id=” .$u_id ." GROUP BY"
|
1
補足
answer
CHANGED
|
@@ -12,4 +12,5 @@
|
|
|
12
12
|
WHERE user_id='$u_id'
|
|
13
13
|
GROUP BY pass='$PASS'
|
|
14
14
|
";
|
|
15
|
-
```
|
|
15
|
+
```
|
|
16
|
+
若しくは文字列連結 ”user_id=” .$u_id ." GROUP BY"
|