--- html/obavijest.php 2000/06/28 07:27:43 1.11 +++ html/obavijest.php 2000/06/28 11:57:55 1.12 @@ -80,7 +80,7 @@ $instaliran=0; -$result = pg_Exec ($conn, "select datum,opis,ime,prezime,status_tip_id as st +$result = pg_Exec ($conn, "select status.id as status_id,datum,opis,ime,prezime,status_tip_id as st from status,kontakt_osobe,status_tip where kontakt_osoba_id=kontakt_osobe.id and status_tip_id=status_tip.id and osoba_id=$id order by datum"); @@ -91,7 +91,11 @@ if ($nr > 0) { for ($i=0; $i<$nr; $i++) { $row=pg_fetch_array($result,$i); - $statusi.="$row[datum]$row[opis]$row[ime] $row[prezime]"; + if ($row[st] != 2) { + $statusi.="$row[datum]$row[opis]$row[ime] $row[prezime]"; + } else { + $statusi.="$row[datum]$row[opis]$row[ime] $row[prezime]"; + } if ($row[st] == 6) { $instaliran = 1; }; } } else {