Hi all,
I have a problem, in that I cannot think how a function on my site can work. The first page that a customer can see when entering my site is a booking page. They choose booking location, date, time etc, and submit this data so the system can search for a vacancy against current bookings. If this comes back clear, and the booking is possible, they are then asked to enter their customer details and payment method.
Problem is, to make a booking you need to have a Customer_ID, but you want get one of these until you have filled in the customer registration form.
My question is, how much information can I carry through from page to page, holding the booking information? I know I can keep POSTing this through, but then I need to INSERT the customers details before I can INSERT the booking details. Where can I hold the booking information whilst I insert the new customer record?
Also, has anyone ever done a complicated booking query before? I'm having real trouble pulling back some data with my query.
Thanks
I have a problem, in that I cannot think how a function on my site can work. The first page that a customer can see when entering my site is a booking page. They choose booking location, date, time etc, and submit this data so the system can search for a vacancy against current bookings. If this comes back clear, and the booking is possible, they are then asked to enter their customer details and payment method.
Problem is, to make a booking you need to have a Customer_ID, but you want get one of these until you have filled in the customer registration form.
My question is, how much information can I carry through from page to page, holding the booking information? I know I can keep POSTing this through, but then I need to INSERT the customers details before I can INSERT the booking details. Where can I hold the booking information whilst I insert the new customer record?
Also, has anyone ever done a complicated booking query before? I'm having real trouble pulling back some data with my query.
Thanks