[SOLVED] Newbie question - WHERE statements

[ShootingBlanks]

Hello.  I have two fields that users can enter dates into, and then I want to pull records that fall only between those two dates (based on the "due_date" column in my table).  I have the fields properly formatted for SQL date format, but is this code for the "WHERE" part of my SQL expression valid? (and if not, what should it be):

 

"WHERE projects.due_date > '".$_GET['date1']."' AND projects.due_date <= '"..$_GET['date2']."'"

 

Thanks!...

 

 

[pocobueno1388]

Try this

 

WHERE projects.due_date BETWEEN {$_GET['date1']} AND {$_GET['date2']}

[ShootingBlanks]

That worked great - thanks!...