is there a way to auto increment a value in a MySQL with PHP without having to lookup the value for instance:

UPDATE SomeTable SET cell=cell++ WHERE row='some_row'

UPDATE table SET cell = cell + 1 WHERE id = 5;

i pretty sure that works.