Hi there,
I have a problem which I can't get my head around and really need to sort.
I have a drop down list of months (january, February etc.) and their values are a two digit int to match the date....I want this to filter a result of lists so people can view events from each month.
However as the dates of the events are stored in the format of '2010-10-5' in the database within a date field, im not sure how to access the middle section of the field to get the month!
I have tried using wild cards around the value like '%%%%-$month-$$', but this doesnt work...however it does within the sql console on php my admin..
if anyone knows a solution or has had a similar problem please let us know!
thanks
