<?php
$conn = "host=localhost dbname=raspisanie user=postgres password=1111";
$dbconn = pg_connect($conn);
$result2 = pg_query($GLOBALS["dbconn"],"SELECT * FROM prepod ORDER BY id_pp");
while($row2 = pg_fetch_array($result2,$i))
{

$id_pp2=$row2['id_pp'];
if ($id_pp=='') {("UPDATE prepod SET nagruzka_tru='' WHERE id_pp='$id_pp2'") or die (pg_last_error ());}
$result = pg_query($GLOBALS["dbconn"],"SELECT * FROM stroka WHERE id_pp='$id_pp2' ORDER BY id_pp");
while($row = pg_fetch_array($result))
{
$id_str=$row['id_str'];
$id_pp=$row['id_pp'];

$result55 = pg_query($GLOBALS["dbconn"],"SELECT *,EXTRACT(EPOCH FROM (vr_end- vr_nach)) AS 'secundi' FROM stroka WHERE id_pp='$id_pp'");
while($row55 = pg_fetch_array($result55))
{
$sec=$row55['secundi'];
if ($sec>0){$summa=$summa+$sec;}
}
echo $id_pp.'--'.$summa.'<br>';

pg_query ($GLOBALS["dbconn"],"UPDATE prepod SET nagruzka_tru='$summa' WHERE id_pp='$id_pp'") or die (pg_last_error ());
$summa=0;
}
//echo $id_pp2.'-'.$id_pp.'<br>';
$id_pp='';

}
$id_str='';

?>