PHP MySQL syntax error - please help

[kaul1jos]

I need to update a field of a database with the following content:
$ILO__NaamIp = 'RILO: SERVER - 145.78.1.119';
$svr = SERVER ;

I tried:
$sql = 'UPDATE `tbl_serverinfo` SET `ILO_NaamIp` = '.$ILO__NaamIp.'WHERE `ServerNaam` = '.$svr.' LIMIT 1';

and got the following 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 ': SERVER - 10.0.0.9

Please help

 

[sleipnir214]

You need singlequotes inside your query, so use doublequotes as your string limiter when constructing the query:

<?php
$ILO__NaamIp = 'RILO: SERVER - 145.78.1.119';
$svr = 'SERVER' ;

$sql = "UPDATE `tbl_serverinfo` SET `ILO_NaamIp` = '" . $ILO__NaamIp . "' WHERE `ServerNaam` = '" . $svr . "' LIMIT 1";
?>

Want the best answers? Ask the best questions!

TANSTAAFL!!