How do I create a "Duplicate Record" button that populates a new increment

[rushingfs]

I am a noobie that wants to modify a script that has a form with a "delete" and "edit" button.  I would like to add a "duplicate" button that will automatically populate the fields with data from user's last record while assigning it a new increment.

Thank you!

[Barand]

Suppose the table has column names id, a, b, c.

$sql = "INSERT INTO tablename (a, b, c) SELECT a, b, c FROM tablename WHERE id = '$selectedID' ";

In other words select all cols form original record [b]except[/b] the id and insert them into the table as a new record. Note it won't work if you have unique key constraints on a, b or c.

[rushingfs]

Thank you for the quick reply.  I'll try that.