Events Diary Creation

Hi,

I started off creating an events diary with little experience of CMS builder as I thought it would be pretty straightforward, select a month and produce a list showing events during that month based on the date search, sounds fine however I have already run into a few issues such as;

a) catering for events which for example are only on specific days between certain dates, I would somehow wish to have these recuring listings automatically displayed in the diary list without having to manually add them.ie If an event took place every thursday during May I would want that item to appear in the list for each Thursday in May. This to me sounds very complex and If I cannot achieve this pretty simply then I think I would be better off just using our existing web calendar program but I would much prefer to have it all within cms builder if possible. Can this be done?

b) If an event starts in April and runs until July I would wish to ensure that searches for events in May and June also showed the event details. I have an event date variable called 'event_date' and have used an end date variable of 'removeDate' , at present my code below simply checks the event_date and if it matches the search month then it will display.

Could someone advise how I would amend this code to display if the search month fell between the 'event_date' and the 'removeDate' which would presumable provide the solution to b) above, sorry if this is elementary stuff but have to start somewhere. Have also come across another issue of where events are only for one day, to prevent removal of the event on the day it occurred I would somehow need to advance the removeDate to the following day or not to remove until midnight of that date. (two steps forward three steps back [unsure])

If you could advise if the whole process is likely to be too complex to achieve it would be appreciated.

Code below

<form method="post" action="diarylist.php">

<table border="0" cellspacing="0" cellpadding="0">

<tr>
<td colspan="2"><br />

<br />
<select name="event_date_month">
<option value="">&lt;Please Select Month&gt;</option>
<option value="">List all Events</option>
<option value="1">January</option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>

</select>
&nbsp;
</p> </p> </td>

</table><br/>


<div align="center">
<input type="submit" name="search" value=" List Events "/>