84 |
kontakt_osobe.ime||' '||kontakt_osobe.prezime as kontakt_osoba, |
kontakt_osobe.ime||' '||kontakt_osobe.prezime as kontakt_osoba, |
85 |
e_mail,kontakt_osoba_id |
e_mail,kontakt_osoba_id |
86 |
"; |
"; |
87 |
$sql_tablice="osobe,org_jed,kontakt_osobe"; |
$sql_tablice="osobe,org_jed,kontakt_osobe,org_pod_jed"; |
88 |
$sql_where="org_jed.id=org_jed_id |
$sql_where="org_jed.id=org_jed_id |
89 |
and org_pod_jed.pod_id=org_pod_jed_id |
and org_pod_jed.pod_id=org_pod_jed_id |
90 |
and kontakt_osoba_id=kontakt_osobe.id |
and kontakt_osoba_id=kontakt_osobe.id |
165 |
<td>$row[orgjed]</td><td>"; |
<td>$row[orgjed]</td><td>"; |
166 |
|
|
167 |
$sth1 = $dbh->prepare("select datum,opis from status,status_tip where status.status_tip_id=status_tip.id and osoba_id=$row[id] order by datum"); |
$sth1 = $dbh->prepare("select datum,opis from status,status_tip where status.status_tip_id=status_tip.id and osoba_id=$row[id] order by datum"); |
168 |
$sth->execute(); |
$sth1->execute(); |
169 |
while ($row1=$sth1->fetchrow_hash()) { |
while ($row1=$sth1->fetchrow_hash()) { |
170 |
print "<small>$row1[datum]</small> $row1[opis]<br>"; |
print "<small>$row1[datum]</small> $row1[opis]<br>"; |
171 |
} |
} |