Editing MySQL rows and fields

[Anon]

hey, i was wondering how would i be able to update a certain row of data without deleting it. (im building a script which depends on ordering data by id number which is an auto_increment, deleting and reentering data would mess up the order.)
PLEASE help!
thankyou in advance

[Anon]

Use the UPDATE query...e.g.

UPDATE tbl_name SET fieldName= 'value' and fieldName2 = 3;

Diego