[SQL ] 請教一下這個錯誤訊息

[sionkozx (sionkozx)]

我用maysql+PHP
以下是錯誤訊息：

SELECT * FROM validate where (serial_number=''9909121913011605' and
v_setting='220' and i_setting='8');

Error: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'9909121913011605' and v_setting='220' and i_setting='8')' at line 1 with
query SELECT * FROM validate where (serial_number=''9909121913011605' and
v_setting='220' and i_setting='8');

我知道問題出在那個引號~
我的temp[2]本身就是'9909121913011605
用過很多種方式還是沒辦法順利搜尋~
serial_number我要儲存為前面有帶一個引號的字串共17碼~
但是都會出現
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in XXXX錯誤。

以下是程式碼：
$query="SELECT * FROM validate where (serial_number='$temp[2]' and
v_setting='$temp[4]' and i_setting='$temp[5]');";

$result=mysql_query($query) or die("Error: ". mysql_error(). " with
query ". $query);
$countone = mysql_num_rows($result);//有幾筆


--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 60.250.193.248
→ lbeeon:加逃脫字元?或者是用cast包起來看看?
→ iFEELing: 碰 到 特 殊 字 元 要 另 外 標 記 啊 大 佬