PHP Auto update

[Evilsprouts]

Hiya everyone,

basically I have a table in mysql and it has a column called "ord" which has different values init according the order I wish the items to be displayed but I want a system which will automatically update all of the values when 1 is changed but I'm not sure the best way to go about it?

Please help me.

Thanks