change the values in a row

[Anon]

I am using mysql and php to to create a table
for example if i display the table

id = 123
name = John Doe
age = 100
status = missing

if i want to change the information so that the table can look like

id = 123
name = jane Doe
age = 99
status = found

how do i get to change the value of the rows in the database.

please help

[Anon]

well..

i would use this.

$update = "UPDATE yourtable SET name='jane Doe', age='99', status='found' WHERE id='123'";

Cheers.

[Anon]

thanks john