In my database I have a date field. I have a php file that gets that information and displays it along with a bunch of other information. These dates are for many different years. I want to sometimes only display dates within a certain subset of these years. The SQL query I've written is:
Select a.mod_id, a.mod_name, b.cat_name, a.mod_list, a.mod_expire, a.mod_beglvl, a.mod_endlvl from dou_modules a, dou_category b where a.mod_cat = b.cat_id and a.mod_expire > "2003-08-05"
However, what happens with this query is that it turns EVERY mode_expire into the last date in that field and displays all of the records instead of displaying only the subset that have dates later than today's date.
Help appreciated.
Thanks.
Denise
