Adding from/to dates on where select query

[cyprus]

I have a series of checkboxes on a page/form which allows the user to dynamically build a WHERE statement.

$where = "WHERE GGroup IN ('$prodlist')";

Is it possible to add into the above a where condition to select records between two dates? Many thanks.

[onlyican]

something like
[code]
<?php
$from_date = "2006-01-01";
$to_date = "2006-09-24";
$query = "SELECT * FROM table WHERE date_added BETWEEN '".$from_date."' AND ".$to_date."'";
?>
[/code]

[cyprus]

Many thanks, that sorted it. Regards