$date_from = $_GET['date_from']; $date_to = $_GET['date_to']; $get = mysql_query("SELECT * FROM accounting WHERE ((date>='$date_from') AND (date<='$date_to'))"); while ($row = mysql_fetch_assoc($get)) { $var1 = $row['var1']; }