Mysql/php update last row then insert a new one?

[craptakular]

Hi,

I have created a database and I need to update the last row of each foreign key, then after this insert a new row with some of the contents copied down and some new ones inserted.

Anyone able to guide me?

id  | title | menu_id   
1    'foo'      1   
2    'bar'      1   
3    'baz'      2

 

[craptakular]

Just started using mysql qorkbench but I will need to automate this into a php script.