$sql = "
SELECT
O.obvestilo_id,
O.naslov,
O.naslov_it,
O.naslov_an
FROM
obvestilo O
WHERE
O.aktivnost = 1
ORDER BY
O.datum";
if (!$result = mysql_query($sql))
{
trigger_error('Failed loading data :' . $sql . ', ' . mysql_error(), E_USER_WARNING );
}
while($row = mysql_fetch_array($result))
{
if($_GET['vsebina'] == $row['obvestilo_id'])
{
$span_start = '';
$span_end = '';
$link_start = '';
$link_end = ''; }
else
{
$link_start = '';
}
echo $span_start . $link_start . stripslashes($row['naslov' . $lang_suff]) . $link_end . $span_end . '
';
}
?>
|
|
if($_GET['vsebina2'] == 'obisk')
{
$sql = "
SELECT
N.besedilo,
N.besedilo_it,
N.besedilo_an
FROM
novost N";
if (!$result = mysql_query($sql))
{
trigger_error('Failed loading data :' . $sql . ', ' . mysql_error(), E_USER_WARNING );
}
$row = mysql_fetch_array($result);
}
else
{
$sql = "
SELECT
O.besedilo,
O.besedilo_it,
O.besedilo_an
FROM
obvestilo O
WHERE
O.obvestilo_id = " . $_GET['vsebina'];
if (!$result = mysql_query($sql))
{
trigger_error('Failed loading data :' . $sql . ', ' . mysql_error(), E_USER_WARNING );
}
$row = mysql_fetch_array($result);
}
mysql_free_result($result);
echo stripslashes($row['besedilo' . $lang_suff]);
?>
|