";
}
}
function najnovsie_spravy($kolko,$kategoria){
$datumm=Date("d.m.y");
$vypis1 = mysql_query("select id,kategoria,title,link,description,pubDate from spravy where ( pubDate like '%$datumm%') AND kategoria=$kategoria order by id DESC LIMIT 0,$kolko");
//bude vypisovat vsetky udaje z db
while ($pole1 = mysql_fetch_row($vypis1)){
$skratene=substr($pole1[2], 0, 35);
echo "$skratene... ";
}
}
/**
* @return void
* @param unknown $kolko
* @desc kolko chceme zobrazit
*/
function dalsie($kolko)
{
$id_kategorie=$_GET['cat'];
$vypis_dalsie = mysql_query("SELECT id, kategoria, nazov from ref WHERE kategoria=$id_kategorie ORDER BY id DESC LIMIT 0,$kolko");
//bude vypisovat vsetky udaje z db
while ($pole = mysql_fetch_row($vypis_dalsie))
{
$skratene=substr($pole[2], 0, 25);
echo "$skratene ... ";
}
}
function pocty($kde,$id_kategorie)
{
$pocet = mysql_query("select count(*) as pocet FROM $kde where kategoria = '$id_kategorie'");
$pocet_udaj = mysql_fetch_array($pocet);
$pocet_sum = $pocet_udaj["pocet"];
echo "$pocet_sum";
}
function vypis_kat_katalog($id_kategorie)
{
$vypis = mysql_query("select id,nazov from subcat WHERE id_kategorie=$id_kategorie LIMIT 0,3");
//bude vypisovat vsetky udaje z db
while ($pole = mysql_fetch_row($vypis)){
echo "$pole[1], ";
}
}
function vypis_box_spravy($id_kategorie)
{
$datumm=Date("d.m.y");
$vypis = mysql_query("select id,kategoria,title,link,description,pubDate from spravy where ( pubDate like '%$datumm%') AND kategoria=$id_kategorie order by id DESC LIMIT 0,1");
//bude vypisovat vsetky udaje z db
while ($pole1 = mysql_fetch_row($vypis)){
echo "$pole1[2] $pole1[2]
";
}
$vypis = mysql_query("select id,kategoria,title,link,description,pubDate from spravy where ( pubDate like '%$datumm%') AND kategoria=$id_kategorie order by id DESC LIMIT 1,5");
//bude vypisovat vsetky udaje z db
while ($pole1 = mysql_fetch_row($vypis)){
$skratene=substr($pole1[2], 0, 40);
echo "$skratene ";
}
}
function kategorie_vyhladavania($tabulka)
{
$vypis=mysql_query("SELECT * FROM $tabulka ORDER BY nazov");
while($pole=mysql_fetch_array($vypis))
{
echo "
";
}
echo "
$skratene...
$skratene ...