how to duplicate a database row

[JoJo]

Hi!

If I have a row with many fields and want to duplicate all of it except for maybe two fields, is there a quick way to do this? I know the long one i.e. reading out all the table_fields into vars and putting them back in again.

It looks something like this:
a table_row with: id, month, year, p1, p2, p3.........
I want to give the user the choice to duplicate the previous months settings for the coming month. the 'id' should be updated by auto_increment, the 'month' and 'year' get their new values through a form. All the other field_values (p1,p2.....) should just be duplicated from the month before.

Thanks for any suggestions
JoJo

[svnfightsvn]

After you insert another row with the month and year data - you can try:

insert into $table (p1,p2,p3....) select p1,p2,p3... from $other_table where id=$id