I'm fairly new to php and very new to MySQL. My question is this, how do I grab the value from the fields startdate and cycle from the database table customer_t?
Basically what I want to do is this: I want to have a form for updating periodic billing information. The startdate and cycle that the customer is on is already in the billing database of our merchant gateway. By using the orderID of the periodic bill, it will search for that order number and then modify the tables with the new information provided in my form.
Problem is this, our merchant gateway, Linkpoint, require that we pass a startdate and periodicity(cycle) in order for the modify to process. I don't want the startdate to change nor the cycle. When the customer first signs up, say for monthly billing, that sets the cycle to 'm1' in the database telling it to bill them every month from the startdate. The startdate is set when the order is placed. So when the customer is using our updatebilling.php form, it simply asks them for the orderID and their new billing information. It doen't ask for the cycle or startdate. If the customer is billed on the 1st of every month but updates their information on the 7th and submit it, it would replace the startdate to the 7th and not bill them on the 1st. I want the billing date to remain the same.
I keep a seperate SQL database of our customers info which has the startdate and cycle but not credit card info. How can I grab those values, the original startdate and cycle from my database and then pass them to the billing database?
I hope this isn't too long of an explanation.
Thanks