Inserting combination auto-increment value

[JayQ]

I want a php script to do this:

I have a database with a row with a value "mega".
I have a php script which adds a row with some info, but the same cell as the mega is supposed to automatically be called mega1. When I add one more row later on it's value will be mega2 etc.
Like a form of auto-increment function, but with a combination of a word and a letter which checks in the database the latest number and adds one.

[devinemke]

1. do the new row INSERT
2. grab the last primary key value ([man]mysql_insert_id[/man] if you use mySQL)
3. do an UPDATE query on the newly created row:

   UPDATE table SET mega_field = CONCAT('mega', $new_row_id) WHERE id = $new_row_id