[RESOLVED] Updating a single row

[ade234uk]

How do I update a single row without needing to update the whole record?

For instance say I just wanted to update the surname
but keep the name and email address

In the past when I have tried to do this I have emptied the complete record on update.

So what I have done to combat this is to extract the contents of the database of the database and assign these to variables and then update the record like this

$ud_name = $row['name'];
$ud_surname = $row['surname'];
$ud_email_address = $row['email_address'];
$ud_id = $row['id'];

$query = "UPDATE test SET name ='$ud_name', surname='$ud_surname', email_address='$ud_email_address WHERE id='$ud_id'";

This is fine for tables that only have 3-4 fields. There must be an easier way?

[Roger_Ramjet]

You should not need to do this, just using

"UPDATE test SET surname='$ud_surname' WHERE id='$ud_id'"; 

should be perfectly OK. If it is not then there is nothing wrong with the query so there is something wrong with the server.

[ade234uk]

This is always some thing that has bugged me in the past. I will give this a go.

[ade234uk]

Thank you very much. I am sure this will take out a lot of hassle in any future projects that I do.