Subquery returns more than 1 row

[Jassim Rahma]

hi, I am doing this stored procedure but getting Subquery returns more than 1 row

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_populate_advertisement`(IN `param_volow_banner_size` varchar(255))
BEGIN
SET @random_banner = (SELECT volow_banner_id FROM volow_banners WHERE volow_banner_size = param_volow_banner_size ORDER BY RAND());
INSERT INTO volow_banner_log (volow_banner_id) VALUES (@random_banner);
SELECT volow_banner_file FROM volow_banners WHERE volow_banner_id = @random_banner;
END

can you help please..

[fjdiewornncalwe]

SET @random_banner = (SELECT volow_banner_id FROM volow_banners WHERE volow_banner_size = param_volow_banner_size ORDER BY RAND());

should be

SET @random_banner = (SELECT volow_banner_id FROM volow_banners WHERE volow_banner_size = param_volow_banner_size ORDER BY RAND() LIMIT 1);

I wasn't, now I am, then I won't be anymore.

[Jassim Rahma]

syntax error

[fjdiewornncalwe]

what db are you using. I wasn't paying attention and assumed MSSQL.

I wasn't, now I am, then I won't be anymore.

[Jassim Rahma]

it's MySQL

[fjdiewornncalwe]

I've updated my original answer to reflect MySql. Sorry for the confusion.

I wasn't, now I am, then I won't be anymore.

[Jassim Rahma]

working now. thanks Marcus

[fjdiewornncalwe]

You are welcome.

I wasn't, now I am, then I won't be anymore.