Can someone help wiht CREATE PROCEDURE

 Table 1
    mID         date             room
    m1          2015.01.01        122
    m2          2016.01.01        151
    m3          2016.07.07        454

 Table 2
    mID       mName
    m1        network
    m2        ood
    m3        java



enter code here

CREATE PROCEDURE that gives a new agenda for a module. I need it to accept the ID and date(1 month in advance) otherwise show error, and then show consequative weeks (e.g next 5 weeks)

I have to use a CURSOR, LOOP and SIGNAL and if (if needed)