Code:
CREATE PROCEDURE peak_trader.ptp_software_order_sp
(IN membershipOption varchar(75),
IN firstName varchar(75),
IN lastName varchar(75),
IN company varchar(75),
IN address varchar(75),
IN city varchar(75),
IN state varchar(75),
IN zip varchar(20),
IN phone varchar(75),
IN emailAddress varchar(75),
IN ccType varchar(20),
IN ccNum varchar(20),
IN ccSecCode varchar(4),
IN ccExpDate varchar(7),
IN dateSubmit datetime,
IN ipAddress varchar(15))
BEGIN
DECLARE thisID INT;
INSERT into peak_trader.users (
user_id, first_name, last_name, status, comment, Account_Num, Cost, DTN_Password, Sales_Code,
membership, company, address, city, state, zip, phone, email, dateSubmit, ipAddress
)
VALUES (
'', firstName, lastName, '', '', '', '', '', '', membershipOption, company, address, city,
state, zip, phone, emailAddress, dateSubmit, ipAddress
)
INSERT into peak_trader.users_cc (
CCType, CCNum, CCExpDate, CCSecNum, users_id
)
VALUES (
ccType, ccNum, ccExpDate, ccSecCode, SELECT LAST_INSERT_ID()
)
END
^_^