update problem

[viraj]

Can someone please help me out with this problem with update:
ERROR:
Could not select database: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 '(Firstname='raj', Lastname='veer', Age='36' where ID='1')' at line 1

Here is the code:
<?
require_once 'masterconfig.php';
$id=$POST['id'];
$fname = $POST['fname'];
$lname = $POST['lname'];
$age= $POST['age'];

$mySQL = "update fullname set(Firstname='$fname', Lastname='$lname', Age='$age' where ID='$id')";
mysql_query($mySQL)or die('Could not select database:' . mysql_error());
?>

Thanks.

[DennisP]

Try changing the query to this:

UPDATE fullname
SET Firstname = '$fname',
Lastname = '$lname',
Age = '$age',
ID = '$id'

[rincewind456]

You have brackets there that shouldnt be, the sql statement should be something like

$mySQL = "update fullname 
setFirstname='$fname', Lastname='$lname', Age=$age where ID=$id";

you also don't need the single qoutes around the numbers for age and id unless you are storing them as strings instead of integers.