[SOLVED] Updating records

[samona]

Hi,

 

If i want to update one field in a record would that work or do i have to update all the fields.  For example, if I have a table

 

Customers
========
First Name
Last Name
Address
Record ID 

If I want to just update the address, do I need to insert the First Name and Last Name again or can I just write a query that updates address for that particular Record ID.

[DEVILofDARKNESS]

$query = "UPDATE Customers SET Address = '$newaddress' WHERE Record ID='$recordid'";