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	ravilov	1.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			?>