Hi, I'm trying to copy some values from a table called "member" to a table called "report" when new members submit a php application form. I can't see what's wrong with it. I have attached screenshots of the 2 tables and their structure. Any help would be much appreciated.
global $conn,$dal;
$customerID = mysql_insert_id();
$strSQLInsert = "insert into report (appID, memberID, select_agent, agent_details, first_name, last_name, street_address, suburb, postcode) values (".$ID.", ".$ID.", '".$values["select_agent"]."', '".$values["agent_details"]."', '".$values["first_name"]."', '".$values["last_name"]."', '".$values["street_address"]."', '".$values["suburb"]."', '".$values["postcode"]."')";
db_exec($strSQLInsert,$conn);
[attachment deleted by admin]