sp_breadcrumb

CREATE  PROCEDURE sp_breadcrumb(IN id_record INT)
BEGIN
SELECT  @r AS _id,
        (
        SELECT  @r := concat(id_parent, ' - ',nama_folder)
        FROM    filemanager_kategori
        WHERE   id = _id order by id_parent desc
        ) AS parent,
        @l := @l + 1 AS lvl
FROM    (
        SELECT  @r := id_record,
                @l := 0,
                @cl := 0
        ) vars,
        filemanager_kategori h
WHERE    @r <> 0  ;
END