INSERT INTO `sale-guests` (idpostcode, firstname, lastname, dateadded, ccdate) VALUES(233, '01', CONCAT('M-', zFirstName), NOW(), ADDDATE(CURDATE(), INTERVAL 1 YEAR); SELECT LAST_INSERT_ID() INTO zNewID;