change the action of the form on the confirm page to post to:
This is the way PayPal standard works.
With paypal standard the checkout page post to the confirm page. Then the confirm page posts to the paypal server where the customer selects how they wish to pay for the order.
since the confirm page posts to paypal, it is not possible to store the order when they click the confirm button.
when working with paypal standard, you should have a status column in your orders table that is initially set to pending.
you will need to configure your account to use IPN, and set up an IPNN Page that will update the status column based on the transaction status info posted from paypal in the IPN post.
there are many posts throughout this forum that talk about paypal and IPN, that will give you more details.
also see the IPN documentation: