i want select data table using 2 columns. i'm trying select table month between february , august , year between 2003 , 2005 including month of january 2004 , 2005. have tried this: `
$number = range(3, 8); foreach($number $key=> $value): $where .= " month ='$value' , year between '2003' , '2005' or " ; endforeach; if(strlen(trim($where)) > 0) $where = substr(trim($where), 0, -2);` $query = "select * mytable $where";
which return following query
select * mytable month ='2' , year between '2003' , '2005' or month ='3' , year between '2003' , '2005' or month ='4' , year between '2003' , '2005' or month ='5' , year between '2003' , '2005' or month ='6' , year between '2003' , '2005' or month ='7' , year between '2003' , '2005' or month ='8' , year between '2003' , '2005'
but problem query is not selecting january of 2004 , 2005. 1 idea of how this?
select * mytable ( month >=2 , month <=8 , year between 2003 , 2005) or (month=1 , (year=2004 or year=2005))
Comments
Post a Comment