2 |
function myCmp($a, $b) { return MyCompare($a["naslov"], $b["naslov"]); } |
function myCmp($a, $b) { return MyCompare($a["naslov"], $b["naslov"]); } |
3 |
function myCmp2($a, $b) { return MyCompare($a["naziv"], $b["naziv"]); } |
function myCmp2($a, $b) { return MyCompare($a["naziv"], $b["naziv"]); } |
4 |
$naslov = ""; |
$naslov = ""; |
5 |
|
if ($spec) $grupa = $spec; |
6 |
if ($grupa) { |
if ($grupa) { |
7 |
$sql = "SELECT opis FROM specijalizacije WHERE (link) AND (spec_id = $grupa)"; |
$sql = "SELECT opis FROM specijalizacije WHERE (link) AND (spec_id = $grupa)"; |
8 |
$sth = $dbh->prepare($sql); |
$sth = $dbh->prepare($sql); |
12 |
$sth->finish(); |
$sth->finish(); |
13 |
if ($row) $row = array_shift($row); |
if ($row) $row = array_shift($row); |
14 |
if ($row) $naslov = $row; |
if ($row) $naslov = $row; |
15 |
$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)":""); |
16 |
$sth = $dbh->prepare($sql); |
$sth = $dbh->prepare($sql); |
17 |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
18 |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |