I can't figure out why this replace stament is throwing a error, can somebody look at the syntax and tell me what I am doing wrong?
$sql = "REPLACE INTO customer_servers
SET company_id='$company_id',server_type_id='1',server_shortname='$value', server_ip='$value2', server_fqdn='$server_fqdn'
WHERE cs_server_id='$fs_cs_server_id'";
mysql_query($sql) or die (mysql_error());
I am getting this error.
You have an error in your SQL syntax near 'WHERE cs_server_id='2'' at line 3