health_html/inc/pgLinkovi.php

<?php
        $sql = "SELECT url, naslov, opis FROM linkovi ORDER BY naslov";
        $sth = $dbh->prepare($sql);
        if (!$sth) error("Cannot prepare query: \"$sql\"");
        if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
        $linkovi = array();
        while ($row = $sth->fetchrow_array())
                array_push($linkovi, array("url" => MyEscape($row[0]), "naslov" => MyEscape($row[1]), "opis" => MyEscape($row[2])));
        $sth->finish();
        $tpl->assign("linkovi", $linkovi);
?>
1	<?php
2	$sql = "SELECT url, naslov, opis FROM linkovi ORDER BY naslov";
3	$sth = $dbh->prepare($sql);
4	if (!$sth) error("Cannot prepare query: \"$sql\"");
5	if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
6	$linkovi = array();
7	while ($row = $sth->fetchrow_array())
8	array_push($linkovi, array("url" => MyEscape($row[0]), "naslov" => MyEscape($row[1]), "opis" => MyEscape($row[2])));
9	$sth->finish();
10	$tpl->assign("linkovi", $linkovi);
11	?>