--- inc/pgKnjiznica-lijekovi.php	2001/09/19 12:23:57	1.3
+++ inc/pgKnjiznica-lijekovi.php	2001/09/25 15:38:04	1.4
@@ -1,5 +1,5 @@
 <?php
-	include_once("inc/conn.php");
+	include("inc/conn.php");
 	include_once("inc/search.php");
 	$fields = array(
 		"atk" => array("dbname" => "lijekovi.sif_atk || lijekovi.sif_atk_ostalo", "caption" => "ATK"),
@@ -15,6 +15,13 @@
 	$tpl->assign("index", $index);
 	$tpl->assign("srch", ($qry_1 || $qry_2) ? true : false);
 	$tpl->assign("SEARCH", $srch);
+	$recepti = array();
+	$sql = "SELECT oznaka, opis FROM recept";
+	$sth = $dbh->prepare($sql);
+	if (!$sth) error("Cannot prepare query: \"$sql\"");
+	if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
+	while ($row = $sth->fetchrow_array()) $recepti[$row[0]] = MyEscape($row[1]);
+	$sth->finish();
 	$letters = Slova();
 	if ($index || ($qry_1 || $qry_2)) {
 		$prvo_slovo = "UPPER(SUBSTRING(lijekovi.naziv FROM 1 FOR 1))";
@@ -51,7 +58,7 @@
 				list($recept, $pakovanje, $atc, $atc2, $cijena) = $row2;
 				array_push($oblici, array(
 					"hzzo" => $recept,
-					"hzzo2" => $recept2,
+					"hzzo2" => $recepti[$recept],
 					"pakovanje" => MyEscape($pakovanje),
 					"atk" => $atc.$atc2,
 					"cijena" => $cijena