Storing Records from the "Bill To"
Hi,
I reran your checkout wizard and when I did that it created a page with "Billing" AND "Shipping" sections, which I have working nicely now, however, I am required to store the Billing Details into a new database. The Shipping details are being stored in my "Orders" database. I have created a new MySQL database called "billing details" and have the following columns: BillingOrderID (This is to be the order id number from the "Orders" database), BillingVisitorID (which will be their email address),BillingCompany, BillingAddress1, BillingAddress2, BillingCity, BillingZip, BillingCountry. How can I store this in this new database.
I know own all the WA extensions through my employer, so should I use DataAssist? I have to tell you, I tried already with no luck. I tried the single insertion (going field by field and inserting one at a time) and I tried the repeat region, but no luck. Could it be that I have the session set wrong? Should the session be named the same throughout all of my checkout pages?
Please note, I am storing this from the "Billing" section on the "checkout.php" page. I have attached my "checkout.php" page for your review. I have attempted to use DataAssist to store the email address from the "Billing Information" section into the BillingVisitorID field of my "billing details" database (please see around line 92). I think it may be something with my "session variable". I am not quite grasping it. Do I have it named wrong? What would be the steps taken when wanting to store only certain fields from the "Billing Information" section of the form into a database using DataAssist?
Do we need to open a new ticket?
Thanks!!!!!!!