hi Everybody,
I am doing project on web based events.
1) I am doing the project with jsp. I want to show the daily events on one hour basis.
like
8am eventDesc
9am eventDesc
-- ---
upto 9pm.
I want to show all the events that are occuring at 8 am. If there is event at any particular time it has show against the time. If there are no events it will show blank space.
How to show that?
2) I want to show last month day event. today ie.,if there is event on 2007-06-10. i have to show the last month event on 2007-07-10. i am getting problem reg sql statement. i have checked both month and day. if these are equal i have to show the event.
sql statement is

select * from Cal_Event where RepStatus='M' AND DAY('"+num+"')= DAY(NOW()) AND MONTH('"+num+"') = MONTH(NOW());

It is not working properly. Am i write or not?
I am using mysql as db.

pl help me
Sai