[RESOLVED] Date range

zzz

I am trying to write a query string that will allow user specify the search date range.

My records have a column with the "date" in the following format 0000-00-00

I can specify the FROM and TO range in the search form. Both FROM and TO have month and year.

Having difficulties with the actual query

SELECT * 
FROM mytable 
WHERE tbl_date(MONTH) < ".$FROMmonth."
AND tbl_date(YEAR) < ".$FROMyear."
AND tbl_date(MONTH) > ".$TOmonth."
AND tbl_date(YEAR) < ".$TOyear."

Doesn't look right, does it? 😕

Merve

What errors are you getting? If you copy-pasted the code, the last < should be a >.

bradgrafelman

Have you tried the BETWEEN syntax in MySQL? I believe that syntax can handle dates... unless I'm mistaken.

Also, what is tbl_date() ? AFAIK, this isn't a function native to MySQL ...

mjax

I guess you are trying to do this:

SELECT *
FROM mytable
WHERE MONTH(tbl_date) >= ".$FROMmonth."
AND YEAR(tbl_date) >= ".$FROMyear."
AND MONTH(tbl_date) <= ".$TOmonth."
AND YEAR(tbl_date) <= ".$TOyear."

zzz

That worked thanks.

zzz

ssa