[SOLVED] Problem Updating Record

[stevesimo]

Hi, I am trying to update a record in my database. Although the code is running, the database record is not being updated.  Here is my code:

 

$result = mysql_query("UPDATE orders SET Address1 = '$address1', Address2 = '$address2', Address3 = '$address3', County = $county, Postcode = $postcode WHERE PolicyID = '$policyid'");

 

PolicyID isnt a primary keyfield, will this make a difference or should the update still be executed?

 

Can anyone see what I am doing wrong?

 

Thanks, Steve (Blackpool) ???

[spfoonnewb]

I see a few syntax issues,

 

$result = mysql_query("UPDATE orders SET Address1 = '$address1', Address2 = '$address2', Address3 = '$address3', County = '$county', Postcode = '$postcode' WHERE PolicyID = '$policyid'") or die(mysql_error());

 

Try that, and if it doesn't work it will produce an error that you can share, or fix.