[問題] PHP+MYSQL SQL LIKE語法無法使用

看板Web_Design作者sarino (soap)時間16年前 (2009/06/01 16:23)推噓2(2推 0噓 3→)

留言5則, 4人參與討論串1/1

-------------------------程式碼------------------------------------- $field = "*"; $table = "bureau_list"; $condition_field = "bureau_number"; $query = "SELECT " . $field . " FROM " . $table . " WHERE " .$condition_field . "= 'L04'"; $result = mysql_query($query) or die("Query failed"); 如果程式這樣寫可以有結果輸出但是如果是要換成 LIKE 以及 % 的比對法 ------------------------程式碼------------------------------------- $field = "*"; $table = "bureau_list"; $condition_field = "bureau_number"; $query = "SELECT " . $field . " FROM " . $table . " WHERE " .$condition_field . "LIKE 'L%'"; $result = mysql_query($query) or die("Query failed"); 就會出現 Query failed 請問是不是設定上哪裡要改 -- -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 163.29.98.120

推

pm2001

06/01 16:28, , 1^F

06/01 16:28, 1^F

推

mosluce

06/01 17:28, , 2^F

06/01 17:28, 2^F

→

sarino

06/01 19:39, , 3^F

06/01 19:39, 3^F