| not really sure what you're after. do you want the SQL or some PHP code?
In SQL you can say something like
UPDATE tablename SET field="value" WHERE otherfield="somevalue";
which would update all rows where "otherfield" is "somevalue".
explain exactly what you want to see happen on the screen. |