Thanks for the timely reply.
I understand how this will work, but I'm afraid I am unsure of the correct syntax.
Where in the PHP document so I insert this statement in order for it to work?
Pertinent parts of of my code:
Code:
//Connect to db
//Handle form
//Define query
$query1 = "INSERT INTO orders (order_date) VALUES ('{$_POST['order_date']}')";
//Code for month, day, year vars inserted here
<?php $order_date=".$year."-".$month."-".$day."; ?>
I've tried a few locations - sample above - without success.