How to duplicate a record in MySQL using PHP
The data assist pages have been working great and I can do just about everything I need in my database... except for one thing... I need to duplicate a record, then edit it with new information before committing it to the database. I can do this in phpmyadmin with no problem, but I'd like to be able to do it from my webpage while I'm on a particular record.
Often times I need to enter a new record where 90% of the information is the same but I just need to change a couple of fields.
Do you have any suggestions how I can accomplish this?