質問編集履歴
1
ご指摘頂いた、行末の『";』を足しました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -58,7 +58,7 @@
|
|
58
58
|
|
59
59
|
<実行できるコード>
|
60
60
|
|
61
|
-
$sql = " SELECT * FROM usrtable WHERE column1 = 'XXXX' AND column2 = 'YYYY'
|
61
|
+
$sql = " SELECT * FROM usrtable WHERE column1 = 'XXXX' AND column2 = 'YYYY'";
|
62
62
|
|
63
63
|
|
64
64
|
|
@@ -80,7 +80,7 @@
|
|
80
80
|
|
81
81
|
<実行できないコード1>
|
82
82
|
|
83
|
-
$sql = " SELECT * FROM usrtable WHERE column1 =? AND column2 =?
|
83
|
+
$sql = " SELECT * FROM usrtable WHERE column1 =? AND column2 =?";
|
84
84
|
|
85
85
|
$param = array('XXXX','YYYY');
|
86
86
|
|
@@ -104,7 +104,7 @@
|
|
104
104
|
|
105
105
|
<実行できないコード2>
|
106
106
|
|
107
|
-
$sql = " SELECT * FROM usrtable WHERE column1 =:col1 AND column2 = :col2
|
107
|
+
$sql = " SELECT * FROM usrtable WHERE column1 =:col1 AND column2 = :col2";
|
108
108
|
|
109
109
|
$param = array('col1' => 'XXXX',col2 => 'YYYY');
|
110
110
|
|