hi,
i am trying to make an outlook type calendar application wherein the user can click on a date and add an entry and that gets stored in the database which gets displayed on the month page. Now the problem that I have is that while adding the entry i ask the user to give the start date and end date and i want to pull out the record for the all the dates between the start date and the end date. to make it more clear my entry is stored as
id: 1
projname: test
start date: 12/06/2001
end date: 12/10/2001
on the calendar month view page i want all dates between 6th and 10th to show the projname. i could only get the proj name for the start date only and not for all the dates between the start and the end date.
does anyone have any ideas how i should do this?
if i add entries recurrsively for all days between the start date and end date this will work but then lot of database space will get wasted. hence i just want to make one entry with the start and end dates and accordingly distribute the display.
looking forward to meeting a genius. :-)
thanks,
mandy
