added SQL statement at checkout.
 

What I need to do is add some information (based on product ordered) into a database at the time that checkout is completed (and successful). I have added a value to product called MID which shows the database the user is to be added to.

So, this is my SQL statement: $sql="INSERT INTO $products[prod_num].mid ( `ID` ,`Name_First` , `Name_Last` , `Address_One` ,`Address_Two` , `City` , `State` ,`Postal_Code` , `country` , `email_address` ,`completed` ) VALUES (
'', $order.firstname, $order.lastname, $order.s_address, NULL , $order.s_city, $order.s_statename, $order.s_zipcode, $order.s_countryname, $order.email, 'N');";

Where does this need to go to get processed at checkout for each item ordered? I'm pulling my hair out!

Have you poked around include/func.php? particularly func_place_order();