[SOLVED] Insert Problem With MYSQL

[atticus]

I am having a problem with the syntax of the where clause in this sql statment in mysql.

 

Error, insert query failedYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = '$id'' at line 5

 

$query = "INSERT INTO user 
SET website = '$website',
url = '$url',
business = '$business'
WHERE id = '$id';"; 
mysql_query($query) or die('Error, insert query failed' . mysql_error());

[Stooney]

Try that, you need backdrops around a field named 'id' as it's used by mysql.

 

$query = "INSERT INTO user 
SET website = '$website',
url = '$url',
business = '$business'
WHERE `id`= '$id';"; 
mysql_query($query) or die('Error, insert query failed' . mysql_error());

[unidox]

Try that, you need backdrops around a field named 'id' as it's used by mysql.

 

$query = "INSERT INTO user 
SET website = '$website',
url = '$url',
business = '$business'
WHERE `id`= '$id';"; 
mysql_query($query) or die('Error, insert query failed' . mysql_error());

 

You are correct, as a safe practice I always stress to enclose most strings with ` due to some reserved words such as group. `group` would fix it.

[revraz]

You can't use INSERT with WHERE.  INSERT means to add a new row, WHERE goes with UPDATE.

 

$query = "UPDATE user

SET website = '$website',

url = '$url',

business = '$business'

WHERE id = '$id';";

 

[Stooney]

You can't use INSERT with WHERE.  INSERT means to add a new row, WHERE goes with UPDATE.

 

$query = "UPDATE user

SET website = '$website',

url = '$url',

business = '$business'

WHERE id = '$id';";

 

 

Can't believe I missed that

[atticus]

 

can't believe I missed it either and than posted for help on this forum!  Oh well, thanks everybody.