Use record from one table to create new record in a different table?

[wwconslt]

Hello,

I'm developing an application with a MySQL back-end. The important tables are "requests" and "projects". I have a basic results page where the user clicks on the request id and is taken to the request details page. What I'd now like to do is give the user the option of clicking a button on the request details page that would create a new "project" record using all of the request data.

Any suggestions on how this can be done?

Thanks for your help.

[jdc44]

I'm probably thinking this is easier than it actually is, but it reads like you want to take all the data in your current request-details page and create a new record in your projects table using that data.

If the button that will create the new record is taking the user to another page, I'd recommend coding the current request-id value into the button via a hidden form input tag:

<input type="hidden" name="request_id" value="<?php print $request_id ?>">

The next page will see that value and you can use it in a select query to get those details values again based on that request_id

Then, write sql to insert those values into your projects table. You just have to pick out which values from your details record you need to use in your insert sql to match up to the fields in your projects table.

Hope this helps.