Выборка по дате

echo '<form method="post" action="">';
echo 'От: <input name="date_from" style="width: 4.8em;" class="input" type="text" id="from" required />До: <input name="date_to" style="width: 4.8em;" class="input" type="text" id="to" required />&nbsp;';
echo '<input type="submit" name="confirmDateFilter" value="ОК">';
echo '</form><br>';
 
@$delivery_list_filter = mysql_query("SELECT * FROM delivery_list WHERE username = '$UserName' AND (date >= '$date_from' AND date <= '$date_to') ORDER BY date");
$result2 = mysql_fetch_array($delivery_list_filter);
@$date_from = $_POST['date_from'];
@$date_to = $_POST['date_to'];
 
if(isset($_POST['confirmDateFilter']) && count($result2) > 0)
{
 
@$date_from = $_POST['date_from'];
@$date_to = $_POST['date_to'];
@$delivery_list_filter = mysql_query("SELECT * FROM delivery_list WHERE username = '$UserName' AND (date >= '$date_from' AND date <= '$date_to') ORDER BY date");
 
echo '<table border="1">';
while($result2 = mysql_fetch_array($delivery_list_filter))
{
@$result3 = mysql_query("SELECT * FROM `managers` WHERE `mLogin`='$UserName';")
or die(mysql_error());
$greeting1 = mysql_fetch_row($result3);
$date = $result2['date'];
$company = $result2['company'];
$getter1 = $result2['getter1'];
$getter2 = $result2['getter2'];
$phone1 = $result2['phone1'];
$phone2 = $result2['phone2'];
$time_from = $result2['time_from'];
$time_to = $result2['time_to'];
$docs = $result2['docs'];
$address = $result2['address'];
$instructions = $result2['instructions'];
$important = $result2['important'];
echo '<tr style="vertical-align: bottom">';
echo '<td>'.$date.'</td>';
echo '<td>'.$company.' ('.$greeting1[1].' '.$greeting1[2].', '.$greeting1[4].')</td>';
if (empty($getter2) && empty($phone2))
{
echo '<td>'.$address.'. '.$getter1.', '.$phone1.'.</td>';
}
else echo '<td>'.$address.'. '.$getter1.', '.$phone1.'. '.$getter2.', '.$phone2.'.</td>';
echo '<td>'.$instructions.'. <b>'.$important.' Время: с '.$time_from.' до '.$time_to.'. Документы '.$docs.'</b></td>';
echo '</tr>';
}
echo '</table>';
}