sessions (i thnk)

Hey Ray

been looking around the forum and the tutorials but cant find what I am looking for and been fumbling around trying to do it but I just need a step by step understanding and 'how to' to get new form inputs on a checkout page to be added to the orders table and to the order email that goes out.

Any and all help as always greatly appreciated.

Jamie

The eCart 6 wizard automatically uses the persistent form... so simply adding the fields to the checkout page should make them available on the subsequent pages just like any other field.

Just look how one of the other fields is referenced and reference the new fields the same way. It will be something like:
<?php echo(WA_getSavedFormValue('[form_id],'[field_name]'); ?>

how would I then use that to get them into the database so that it can be displayed in the order_details page?

You would add a column to the orders table and not the order details table (order details is for items per row in the cart not general information from the order). Then you refer the fields in the Store Cart Summary in database the same way the fields that are already there are referred to, just copy one of the others and change the field name.

I had already added the fields to the order table (the order_details I referenced above was the page in the back end to view the order details)

Right

on the pp_confirm.php page I have added the 2 conditional queries:

$ConditionalQuery->bindColumn("PracticeName", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Practice_name_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Practice_name'))))  ."", "WA_DEFAULT");
	$ConditionalQuery->bindColumn("EyeTestConfirmation", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Eye_test_confirmation_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Eye_test_confirmation'))))  ."", "WA_DEFAULT");

But the columns in the db table (PracticeName and EyeTestConfirmation) are not getting populated.

Not sure if I have missed anything with those fieds on the checkouot.php page ?

It should just be:

$ConditionalQuery->bindColumn("PracticeName", "s", "".(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Practice_name'))  ."", "WA_DEFAULT");
    $ConditionalQuery->bindColumn("EyeTestConfirmation", "s", "".(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Eye_test_confirmation'))  ."", "WA_DEFAULT");

But really I would think your version would have worked. Maybe contact me via skype and I'll take a few minutes to debug it with you this afternoon.

:( for some reason although I am going through to paypal and the transaction is going throught there, we'[re back to the details not being passed to the database at all (which may explaiun why I am not seeing the above info being entered as well!)

Let's debug this together in screen sharing.