I have Made a button using :
// Page Data Rendering event
function Page_DataRendering(&$header) {
// Example:
$header = "<button class='btn ewButton' name='convertapp' id='convertapp' type='submit'>Convert to Application</button>";
}
what i want the button to do is take the data from the the current record and insert it into another table. the Tables are leads and applications. all the fields in the lead table are in application, there are however more fields in the application table.
any idea where to add the :
INSERT INTO applications
(CustomerID
, UserID
, AssignTO
, Name
, Surname
, ID_Number
, Address
, Contact_number
, Email
, Bank
, Salary_amount
, Salary_Frq
, Salary_method
, Employer
, Occupation
, Employment_type
, start_date
, Drivers_license
, VehicleSelect
, credit_bureau
, payment_explained
, advertising_explianed
, DebtR
, CreditCheck
, AppCreated
, AppUpdated
, LeadSource
, DVL
, Bank_sta
, POA
, ID_Copy
, Status
) VALUES ([value-1],[value-2],[value-3],[value-4],[value-5],[value-6],[value-7],[value-8],[value-9],[value-10],[value-11],[value-12],[value-13],[value-14],[value-15],[value-16],[value-17],[value-18],[value-19],[value-20],[value-21],[value-22],[value-23],[value-24],[value-25],[value-26],[value-27],[value-28],[value-29],[value-30],[value-31],[value-32]).
and where would i get the Values varibles ? sorry still noob on phpmaker.
my general understanding would have been the form creates a varible $name and i can pull this if my button submits to a convertapp.php.