This topic is locked

Copy Record From Table to Table

1/13/2014 8:02:38 PM
PHPRunner General questions
D
dustinforehand author

Hello Everyone... Was wondering if anyone could help me with the following question.
I have a 2 tables that are the same (id, date_create, user, email, closer, schedule_date).

I would like to have on the list page 2 buttons - Approve / Deny

When approve is pressed it will copy the record to the 2nd identical table and send a confirmation email , when I press deny it will send an email say that the request has been denied

Sergey Kornilov admin 1/14/2014

Take a look at this example:

http://xlinesoft.com/phprunner/docs/update_multiple_records.htm
Instead of updating the record you can create a copy of record in another database table.