Расчет квартплаты

<?
error_reporting(E_ALL);
require_once("login.php");
mysql_connect($host,$user,$passw) or die ("Соединение отсутствует");
mysql_select_db($db);
if ($_GET["submit"])
{
   $query="SELECT b.nazvanie, (CASE WHEN f.id =1
THEN d.pokazaniya * c.stavka
WHEN f.id =2
THEN e.kol_jilcov * c.stavka
WHEN f.id =3
THEN e.plochad * c.stavka
END 
) AS summa
FROM Uslugi_na_lic_schetah a
INNER JOIN Uslugi b ON a.n_uslugi = b.n_uslugi
INNER JOIN Tarify c ON b.n_uslugi = c.n_uslugi
AND c.n_tarifa = a.n_tarifa
INNER JOIN Lic_scheta e ON a.n_scheta = e.n_scheta
INNER JOIN Vid_rascheta f ON c.vid_rascheta = f.id
LEFT JOIN Schetchiki d ON a.n_schetchika = d.n_schetchika
WHERE e.n_scheta=$_GET[schet]";
   $res=mysql_query($query);
   if ($res) 
   { 
            echo "<TABLE> <TR> <TH> Наименование услуги </TH> <TH> Сумма </TH> </TR>";
 
            while ($row=mysql_fetch_array($res))
            {
                  echo "<TR> <TD> $row[0] </TD> <TD> $row[1] </TD> </TR>";
            }
            echo "</TABLE>";
            echo "Итого:";
$query1="Select sum(case when f.id=1 then d.pokazaniya*c.stavka
   when f.id=2 then e.kol_jilcov*c.stavka
   when f.id=3 then e.plochad*c.stavka end) from Uslugi_na_lic_schetah a inner join Uslugi b on a.n_uslugi=b.n_uslugi 
inner join Tarify c on b.n_uslugi=c.n_uslugi AND c.n_tarifa = a.n_tarifa
   inner join Lic_scheta e on a.n_scheta=e.n_scheta 
inner join Vid_rascheta f on c.vid_rascheta=f.id left join Schetchiki d on a.n_schetchika=d.n_schetchika
where e.n_scheta=$_GET[schet]";
$res1=mysql_query($query1);
$row1=mysql_fetch_array($res1);
echo("$row1[0]");
 
   }
   else
   echo "Данных нет!";
} 
?>

<?
$query2=("select n_scheta from Lic_scheta ");
$res2=mysql_query($query2);
while($row2=mysql_fetch_array($res2))
{
echo"<option value='".$row2[n_scheta]."'>".$row2[n_scheta];
echo"</option>";
}
?>

$query="SELECT b.nazvanie, (CASE WHEN f.id =1
THEN d.pokazaniya * c.stavka
WHEN f.id =2
THEN e.kol_jilcov * c.stavka
WHEN f.id =3
THEN e.plochad * c.stavka
END 
) AS summa
FROM Uslugi_na_lic_schetah a
INNER JOIN Uslugi b ON a.n_uslugi = b.n_uslugi
INNER JOIN Tarify c ON b.n_uslugi = c.n_uslugi
AND c.n_tarifa = a.n_tarifa
INNER JOIN Lic_scheta e ON a.n_scheta = e.n_scheta
INNER JOIN Vid_rascheta f ON c.vid_rascheta = f.id
LEFT JOIN Schetchiki d ON a.n_schetchika = d.n_schetchika
WHERE .........";