Gonna mad due to Update problem plzz help urgent

[MohsinAli]

I wrote following query;

$Query = "UPDATE customer SET firstname = " . $formVars["first_Name"] .
             "WHERE cust_id = " . $customerID; 

But following error is being occured;

Error 1064 : 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 'cust_id = 1' at line 1

Actually it should update the record whose id is

$customerID 

which is '1' in this case, in the field

firstname 

with the data in

$formVars["first_Name"] 

.

plzz help me.........

[Atealtha]

Put a space right before the WHERE in the quotes.

[MohsinAli]

I put the space but Now the error is

Error 1054 : Unknown column 'Mohsin' in 'field list'

Mohsin is the actual content which was to be updated.

Waiting for reply...............>>>>>>>>>>

[bhinard]

try this

 $Query = "UPDATE customer SET firstname = " . $formVars["first_Name"] .
             "WHERE cust_id = '{$customerID}'; 

[MohsinAli]

No will need to put a " before ;

but it is showing the very first one error. :'(

[Ramneek]

Here is the solution for your problem

$query=("update customer set firstname='$formVars[first_Name]' WHERE cust_id='$customerID' ");

This code will work definately.

[zfade3]

I put the space but Now the error is

Error 1054 : Unknown column 'Mohsin' in 'field list'

Mohsin is the actual content which was to be updated.

Waiting for reply...............>>>>>>>>>> :rolleyes:

This error almost always comes because there are no 'single quotes' around the value that your are trying to campare with. Sometimes MySQL will guess correctly and match the column with the value, but other times it will give an unknown column error. It is always best to but the single quotes around the values as Ramneek has done.

Jimmy Z