Запрос из БД с группировкой и суммированием

SELECT workout.fio, Sum(workout.kolvo) AS [Sum-total], workout.doc_type, workout.dat
FROM workout
GROUP BY workout.doc_type, workout.fio
HAVING (((workout.fio)="'.$name.'") AND ((workout.dat) Between [$date1] And [$date2]));

<meta http-equiv="Content-type" content="text/html;charset=utf8"> 
 
<?php
include_once("config.php");
checkLoggedIn("yes");
 
if (isset($_SESSION["login"]) && $_SESSION["login"] != "")
{
    //echo "вы залогинились как: ".$_SESSION["login"]."\n <br>";
    $prname = $_SESSION["login"];
    $getname = "SELECT fio, groupa FROM users WHERE login='".$prname."'";
    //echo "строка запроса: $getname \n <br>";
    $printname = mysql_query($getname);
     $numrows = mysql_num_rows($printname) || die(mysql_error());
    if($numrows > 0) {
        $names = mysql_fetch_array($printname);
        $name = $names[0];
        $gr = $names[1];
    } else {    
    echo "че-т не то\n <br>";
}
}
//print ("<a href=\"logout.php"."\">EXIT</a>");
 
$date1 = $_POST['1_dat'];
$date2 = $_POST['2_dat'];
 
print "<br><center>Товарным кассиром <b>$name</b> за период с <b>$date1</b> по <b>$date2</b> отработано:<br><br>";
 
$reqst = "SELECT fio, doc_type, Sum(kolvo) AS kl, dat
FROM workout
GROUP by doc_type
WHERE fio=$name AND dat BETWEEN $date1 and $date2";
$result = mysql_query($reqst);
$resultat = mysql_num_rows($result) || die(mysql_error());
if ($resultat > 0) {
$alle = mysql_fetch_array($result);
 
do
{
echo "<table border=0 width=300><tr>
<td width=200>".$alle['doc_type']."</td><td>".$alle['kl']."</td></tr></table> ";
}
 
while($alle = mysql_fetch_array($result));
}
 
?>

$reqst = "SELECT fio, doc_type, Sum(kolvo) AS kl, dat
FROM workout
GROUP by doc_type
WHERE fio='$name' AND dat BETWEEN $date1 and $date2";