ID incrementing for multiple users - please help

[eluser]Michael Wales[/eluser]
or just manually increment it

Code:

update invoices set num = (SELECT num FROM invoices WHERE user_id = 1 ORDER BY num DESC LIMIT 1,0) + 1 WHERE user_id = 1

Not sure if that is valid SQL - look up subqueries in the MySQL docs.