DELIMITER //
CREATE DEFINER=`root`@`localhost` FUNCTION `formatMovieNames`(lID int) RETURNS varchar(1000) CHARSET latin1
BEGIN
DECLARE output varchar(1000);
DECLARE done INT DEFAULT 0;
declare a varchar(200);
declare cur1 cursor for select fileName from swlp4_movie where movieID in
(select movieID from lesson_movie_map where lessonID = lID order by lm_map_id);
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
open cur1;
read_loop: loop
fetch cur1 into a;
if done = 1 then
leave read_loop;
end if;
set output = concat(output, 'movie:[',a,']<br/>');
set output = substr(output, 0, length(@output)-5);
end loop;
close cur1;
RETURN output;
END//
I have create this function and when I run it I do not get any output
(select fileName from swlp4_movie where movieID in
(select movieID from lesson_movie_map where lessonID = 24 order by lm_map_id));
brings correct result
I am trying to get result as
movie:['movieName']< br / movie:['movieName1'] and so on
(had to change br tag, cause it was adding a line break)
cant't figure out what I am doing wrong
