blackrooksix Posted October 30, 2014 Share Posted October 30, 2014 I am attempting to create a procedure based on add_to_cart(), but am getting a SQL Syntax error. DELIMITER $$ CREATE PROCEDURE add_to_cart(uid CHAR(32), item_type VARCHAR(7), item_id MEDIUMINT, opt1 VARCHAR(32), opt2 VARCHAR(32), qty TINYINT) BEGIN DECLARE cart_id INT; SELECT id INTO cart_id FROM carts WHERE user_session_id=uid AND item_type=item_type AND item_id=item_id AND option_1=opt1 AND option_2=opt2; IF cart_id > 0 THEN UPDATE carts SET quantity=quantity+qty, date_modified=NOW() WHERE id=cart_id; ELSE INSERT INTO carts (user_session_id, item_type, item_id, option_1, option_2, quantity) VALUES (uid, item_type, item_id, opt1, opt2, qty); END IF; END$$ DELIMITER ; Clearly, I have added a few columns, but believe I am accounting for them correctly. In reading the MySQL documentation, it recommends 'SELECT id INTO @cart_id...' and that, too, fails. So I am at a loss as to where I am munging the syntax here. Link to comment Share on other sites More sharing options...
Larry Posted October 31, 2014 Share Posted October 31, 2014 What is the actual error you're getting? Link to comment Share on other sites More sharing options...
Recommended Posts