ok..here's the thing..
I have a calendar app that is really starting to bug me..
www.corruption.co.uk/events/calendar.asp
I have response.written the SQL command and the results so you can see
exactly what is happening.
The DB contains four entries. one each for the 27th of Jan, Feb, March and
April. these four entries are virtually identical (just the name field and
dates are different). the start times are the same, end times etc.
However..the SQL statement only picks up the ones in february ( in this case
27/02/04). all the events were stored using the same piece of code for
adding new events. I can change the dates as much as I like but still it
only picks up the dates in february.
does anyone know why is this happening??..
I thought that if this was a date thing then 27/1 could only possibly be
taken as being in the dd/mm format. so why would it change for any of the
other dates?