Get records betwen two date columns.

[Julian]

Hello

 

Maybe is silly but I know I can find a solution here.  I have this table

 

id    |    datein        | dateout

1      |  2007-05-11    | 2007-10-11

2      |  2007-06-11    | 2007-10-11

 

What I'm trying to do is get all the records between date I passed via form.

 

I tried

"Select * from dates WHERE datein >= '$datein' AND dateout <= '$dateout'";

 

I stored dates as DATE on the DB.  I tried to use BETWEEN, but I don't know if I can use on two different columns.

 

Thanks for the help guys.

[Barand]

What was wrong with

 

"Select * from dates WHERE datein >= '$datein' AND dateout <= '$dateout'";

[Julian]

With this Select I do not get the results I want.  It seems only work with year.

 

I want to list the dates (including day and month) that are between datein and dateout only.  Thanks

$datein = 2007-05-12
$dateout = 2007-06-12

[Barand]

What does this output

 

 

echo "Select * from dates WHERE datein >= '$datein' AND dateout <= '$dateout'";

[Julian]

Hi

 

I get the desired records if I change the variables for the exact dates that are stored on datein and dateout.  It seems that the >= or <= is not working for my purposes.  Because the in between dates doesn't show up when I change the datein or dateout input, even if the dates I put are in range.