Escaping SQL ?

[Anon]

Hiya,

Question is when i'm doing a SQL to lookup a database that has a IP addres.. The SQL isn't matching.. i.e SELECT * FROM linux_servers WHERE ip=xxx.xxx.xxx.xxx isn't matching.. is there an escape sequence i'm forgetting? its just comming up with Supplied argument is not a valid MySQL result resource

[kaptainkory]

You probably just want to do something like this:

$query = 'SELECT * FROM linux_servers WHERE ip=xxx.xxx.xxx.xxx';
$query = mysql_escape_string($query);
$result = mysql_query($query);

Hope this solves it.

kory

[[deleted]]

Tried quoting the ip number?

SELECT *
FROM table
WHERE ip='xxx.xxx.xxx.xxx';