--- inc/pgLinkovi.php 2001/10/05 15:10:53 1.2 +++ inc/pgLinkovi.php 2001/10/27 16:54:50 1.3 @@ -2,6 +2,7 @@ function myCmp($a, $b) { return MyCompare($a["naslov"], $b["naslov"]); } function myCmp2($a, $b) { return MyCompare($a["naziv"], $b["naziv"]); } $naslov = ""; + if ($spec) $grupa = $spec; if ($grupa) { $sql = "SELECT opis FROM specijalizacije WHERE (link) AND (spec_id = $grupa)"; $sth = $dbh->prepare($sql); @@ -11,7 +12,7 @@ $sth->finish(); if ($row) $row = array_shift($row); if ($row) $naslov = $row; - $sql = "SELECT url, naslov, opis FROM linkovi, link_spec".($spec?", link_spec":"")." WHERE (linkovi.link_id = link_spec.link_id) AND (link_spec.spec_id = $grupa)".($spec?" AND (link_spec.spec_id = $spec)":""); + $sql = "SELECT url, naslov, opis FROM linkovi".($spec?", link_spec":"")." WHERE (linkovi.link_id = link_spec.link_id) AND (link_spec.spec_id = $grupa)".($spec?" AND (link_spec.spec_id = $spec)":""); $sth = $dbh->prepare($sql); if (!$sth) error("Cannot prepare query: \"$sql\""); if (!$sth->execute()) error("Cannot execute query: \"$sql\"");