Using some response.write()'s I came up with this.
First time through:
ADD STUDENT1: INSERT INTO tbl_Students (StudentBuyerID,StudentUserName,StudentPassword,StudentGender,StudentFirstName,StudentLastName,StudentEmail,StudentAddress1,StudentAddress2,StudentCity,StudentStateProv,StudentCountry,SudentZipPost) VALUES (1,'core','learning','1','Core','Learning','g@learning.com','2244 Somewhere','','Port Hope','Ontario','Canada','M2P 2A9')
ADD STUDENT2: SELECT StudentID FROM tbl_Students WHERE StudentBuyerID = 1 AND StudentUserName LIKE 'core%' AND StudentPassword LIKE 'learning%' AND StudentGender LIKE '1%' AND StudentFirstName LIKE 'Core%' AND StudentLastName LIKE 'Learning%' AND StudentEmail LIKE 'g@learning.com%' AND StudentAddress1 LIKE '2244 Somewhere%' AND StudentAddress2 LIKE '' AND StudentCity LIKE 'Port Hope%' AND StudentStateProv LIKE 'Ontario%' AND StudentCountry LIKE 'Canada%' AND SudentZipPost LIKE 'M2P 2A9%' ORDER BY StudentID DESC
ADD CART SUMMARY3: insert into tbl_Orders (OrderReferenceID,OrderBuyerID,OrderStudentID,OrderSubTotal,OrderDiscount,OrderTax,OrderTotal,OrderCardType,OrderCardNumber,OrderCardHolder,OrderCardExpire) values ('2009100618402201475',1,1,'$40.00','$0.00','$5.20','$45.20','Visa','......1111','Core Learning','02/10')
ADD CART SUMMARY4: select OrderID from tbl_Orders where OrderReferenceID='2009100618402201475' AND OrderBuyerID=1 AND OrderStudentID=1 AND OrderSubTotal='$40.00' AND OrderDiscount='$0.00' AND OrderTax='$5.20' AND OrderTotal='$45.20' AND OrderCardType='Visa' AND OrderCardNumber='......1111' AND OrderCardHolder='Core Learning' AND OrderCardExpire='02/10' order by OrderID DESC
ADD CART DETAIL1: Delete from tbl_OrderDetails where DetailOrderID = 1
ADD CART DETAIL2: insert into tbl_OrderDetails (DetailOrderID,DetailCourseID,DetailCourseName,DetailQuantity,DetailPrice,DetailSubscriptionType) values (1,286079434,'English Grammar I','1','$40.00',4)
Second time through (do not need to add student because we added firsttime):
ADD CART SUMMARY1: select OrderID from tbl_Orders where OrderID = 1 order by OrderID DESC
ADD CART SUMMARY2: update tbl_Orders SET OrderReferenceID = '2009100618441101478', OrderBuyerID = 1, OrderStudentID = 1, OrderSubTotal = '$40.00', OrderDiscount = '$0.00', OrderTax = '$5.20', OrderTotal = '$45.20', OrderCardType = 'Visa', OrderCardNumber = '......1111', OrderCardHolder = 'Core Learning', OrderCardExpire = '03/11' where OrderID = 1
ADD CART DETAIL1: Delete from tbl_OrderDetails where DetailOrderID = 1
ADD CART DETAIL2: insert into tbl_OrderDetails (DetailOrderID,DetailCourseID,DetailCourseName,DetailQuantity,DetailPrice,DetailSubscriptionType) values (1,286079302,'English Grammar II - Essentials','1','$40.00',4)