minus4

looks okay apart from bid if you have bid in both tables then it should be b.bid IN () also why don't it work???? that don't really explain, did it error, or not bring back results? did you run an explain? to see what tables return what results! also u don't really want all the bids, don't u want the highest bid, done for that auction ID??? why don't you simple select then order by bidamount ASC and limit to 1, this will give you the same results right?

procedure sp_test(blah, blah) begin declare a INT default 0; DECLARE b INT DEFAULT 0; DECLARE answer INT DEFAULT 0; SELECT a,b INTO a,b FROM table; IF (a=X AND b=Y) THEN SET answer = 1; ELSE SET answer = 0; END IF; SELECT ANSWER; end; you could change the int for a bool, but you get the idea ! :-)

wouldn't changing your = to IN () bring back your multiple results, but i dont see how you can get 2 users to bid the same amount ???? and both win! if you somehow do then it goes to the person that bid last

hi there, i have the need to run 2 different SQL statements depending on what info i receive, i have put together an example stored procedure that errors on the DECLARE cur1 line. DELIMITER $$ DROP PROCEDURE IF EXISTS sp_TEST $$ CREATE PROCEDURE sp_TEST(IN tester INT) BEGIN DECLARE done INT DEFAULT 0; DECLARE prodid INT DEFAULT 0; DECLARE mysql TEXT; IF (tester=1) THEN DECLARE cur1 CURSOR FOR SELECT productId FROM products WHERE live=1; < -- ERROR HERE ELSE DECLARE cur1 CURSOR FOR SELECT productId FROM products WHERE live=0; END IF; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1; OPEN cur1; FETCH cur1 INTO prodid; REPEAT UNTIL done END REPEAT; CLOSE cur1; SELECT prodid; END $$ DELIMITER ; ERROR: you have an error in your sql syntax blah blah........... (1064) please don't concentrate on what it delivers or what the procedure might do, the problem is with the IF statement. Would appreciate your help if thats possible. thanks