include ("tabla.inc.php");
@ $db = mysql_pconnect("localhost", "mpletiko", "575414");
if (!$db)
{
echo "Spajanje na bazu nije uspjelo";
exit;
}
mysql_select_db("drstudent");
$tabl="Novosti";
$query="select * from $tabl order by datum DESC, ID DESC";
$result=mysql_query($query);
$num_results = mysql_num_rows($result);
if ($num_results<10)
{
$a = $num_results;
}
else
{
$a=10;
}
for ($i=1; $i<$a+1; $i++)
{
$row = mysql_fetch_array($result);
$m = $row["naslov"];
$n = $row["short_text"];
$k = $row["ID"];
$j = $row ["datum"];
$p = $row ["potpis"];
$o =1;
if ($row ["long_text"] == "")
{
$o=0;
}
$slika = htmlspecialchars (stripslashes($row['slika']));
tablice ($m, $n, $k, $j,$p, $tablica, $slika, $o);
}
?>
|