Untitled

mail@pastecode.io avatar
unknown
plain_text
4 years ago
1.1 kB
11
Indexable
Never
We are updating in following tables below according to fields

Fields            Table name 1                         Table name 2
1) First name     clients (billing_firstname)          orders  (custfirstname)  where session orders & orderstatus ("Scheduled","Open")
2) Last name      clients (billing_lastname)		   orders  (custlastname)  where session orders & orderstatus ("Scheduled","Open")
3) Email          clients (email)	                   orders  (custemail1 )  where session orders & orderstatus ("Scheduled","Open")
4) Password       clients  (password)                  No update here..
5) Phone No.      No updated here..                    orders  (billphone )  where session orders & orderstatus ("Scheduled","Open")
6) Shipping Addr. No updated here..                    orders  (custaddress1,custaddress2,custcity,custstate,custzip )  where session orders & orderstatus ("Scheduled","Open")
7) Billing Addr.  No updated here..                    orders  (billaddress1,billaddress2,billcity,billstate,billzip )  where session orders & orderstatus ("Scheduled","Open")