[SOLVED] SQL query - with 4 condition

[md2d]

i have 2 parameters: $start_date and $end_date,

How do I get list project in a range start_date and end_date ?

 

this query view all project,

$que = "SELECT project_id, project_company, project_name FROM projects WHERE

        project_start_date >='$start_date' AND project_end_date <='$end_date' OR

        project_start_date <='$start_date' AND project_end_date <='$end_date' OR

        project_start_date <='$end_date' AND project_end_date >='$end_date' OR

        project_start_date <='$start_date' AND project_end_date >='$end_date'

ORDER BY project_company ASC";

 

but i need to view in a range $start_date and $end_date

 

                |-------?--------|

$start_date <----range------> $end_date

 

anyone know, please help me

 

thanks.

----

md2*

 

[fenway]

You where clause will currently return pretty much all combinations of start/end... so why include it?  For the "true" range, use BETWEEN.

[md2d]

^{$que = "SELECT project_id, project_company, project_name FROM projects WHERE ((project_start_date >='$start_date' and project_end_date <='$end_date') or (project_start_date <='$end_date' and (('$end_date' <= project_end_date) and (project_end_date <='$end_date'))) or ((('$start_date' <= project_start_date) and (project_start_date <= '$end_date')) and project_end_date >= '$end_date') or (project_start_date <='$start_date' and project_end_date >='$end_date') and project_active='1') ORDER BY project_company ASC";}

 

thanks for reply fenway..........