No worries, I thought that is was you meant so i tried it that way before. I have made the changes but I think it got worse.
These are the errors that come up now.
Notice: Undefined variable: t0y0t1r3s in /var/www/html/toyo_support_site/support/Display/confirm.php on line 221
Notice: Undefined variable: database_t0y0t1r3s in /var/www/html/toyo_support_site/support/Display/confirm.php on line 234
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/html/toyo_support_site/support/Display/confirm.php on line 236
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/html/toyo_support_site/support/Display/confirm.php on line 270
Now i did some changes to the email as well and am wondering if this has caused the erros. Basically in the version before it was supposed to pull a sales reps email. I have now set up a recordset and am pulling it that way. I proved that the email is comming in OK by plaing it on the page (see Error2_aug3.jpg). I attached the new confirm.php as it sits now as well as the checkout.php page.
It is all getting to the confirm page OK but once you hit the "submit order" button then the errors happen and it stays on the confirm page.