| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
added SQL statement at checkout. | |||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
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! |
|||||||
|
|||
X-Cart forums © 2001-2020
|