$i=0;
$result=mysql_query("SELECT t.*,r.naziv rNaziv FROM tekst t LEFT JOIN rubrika r on r.id=t.rubrika WHERE t.naslovna=\"da\" AND t.jezik=\"ENG\" AND t.prikaz=\"DA\" ORDER BY t.dat DESC, t.id DESC LIMIT 0,4");
while($data=mysql_fetch_array($result)){
if (($i%4)==0) echo "";
echo "";
?>
echo $data["rNaziv"];?>  " title=" echo $data["naziv"];?>" >
|
|
|
echo " | ";
$i++;
if (($i%4)==0) echo " ";
}
?>
|
|
$result=mysql_query("SELECT t.*,r.naziv rNaziv FROM tekst t LEFT JOIN rubrika r on r.id=t.rubrika WHERE t.naslovna=\"da\" AND t.jezik=\"ENG\" AND t.prikaz=\"DA\" ORDER BY t.dat DESC, t.id DESC LIMIT 0,3");
while($data=mysql_fetch_array($result)){
$txt=strip_tags($data['podnaslov']);$txt=str_replace(' ','',$txt);
if (strlen($txt)<60) $tekst=$data['podnaslov']; else $tekst=substr($txt,0,60)."... ";
?>
}
?>
|
  |
|
|
Latest:
$result=mysql_query("SELECT * FROM tekst WHERE jezik=\"ENG\" AND prikaz=\"DA\" order by dat DESC, id DESC LIMIT 0,10");
while($data=mysql_fetch_array($result)){ ?>
- ">
echo $data["naslov"];?>
} ?>
|