Hi there

Very new to php - is anyone able to tell me what the correct syntax - this is what I have:

$sql = "INSERT INTO `User` SET `txtName`='$txtName', `txtUsername`='$txtUsername', `txtPassword`='$txtPassword' WHERE `fUserid`='$id'";

but I'm getting this error:

Invalid query: 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 'WHERE `fUserid`='2'' at line 1

thanks alot

seems like you are updating the data and not inserting.

Try the following:
$sql = "UPDATE `User` SET `txtName`='$txtName', `txtUsername`='$txtUsername', `txtPassword`='$txtPassword' WHERE `fUserid`='$id'";

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

$sql = "INSERT INTO 'User' values( 'txtName'='$txtName', 'txtUsername'='$txtUsername', 'txtPassword'='$txtPassword' WHERE 'fUserid'='$id')";