beginnerz
04-11-2006, 10:06 PM
hi,
if i have 2 date: from f_month 1 f_year 2006
to t_month 6 t_year 2006
how do i select the data between these 2 date from database which is in datetime?
for example:
select * from table where last_update between (month(".$_GET['f_month.") and year(".$_GET['f_year'].")) AND (month(".$_GET['t_month.") and year(".$_GET['t_year']."))
if i have 2 date: from f_month 1 f_year 2006
to t_month 6 t_year 2006
how do i select the data between these 2 date from database which is in datetime?
for example:
select * from table where last_update between (month(".$_GET['f_month.") and year(".$_GET['f_year'].")) AND (month(".$_GET['t_month.") and year(".$_GET['t_year']."))