$query = "Begin; INSERT INTO `customer`(`firstname`, `lastname`, `address1`, `address2`, `city`, `postcode`, `telephonenumber`, `email`) VALUES ('$firstname','$lastname','$address1', '$address2', '$city', '$postcode', '$telephonenumber', '$email');
SELECT LAST_INSERT_ID() INTO @lastID;
INSERT INTO `vehicle`(`vehicleregistration`, `makemodel`, customernumber) VALUES ('$vehicleregistration','$makemodel', @lastID);
INSERT INTO `job`(`jobdate`, `jobtime`, `servicedetails`, customernumber) VALUES ('$jobdate','$jobtime','$servicedetails', @lastID)Commit;";