//$result = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC LIMIT 0,4");

$result = dbquery(

"SELECT * FROM ".DB_NEWS." 

WHERE news_draft='0' AND news_cat=22 ORDER BY news_datestamp DESC 

LIMIT ".$_GET['rowstart'].", $items_per_page"

);

 $items_per_page = "10"; // limitas kiek rodys naujienų

 

//$result = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC LIMIT 0,4");

$result = dbquery(

"SELECT * FROM ".DB_NEWS." 

WHERE news_draft='0' AND news_cat=22 ORDER BY news_datestamp DESC 

LIMIT ".$_GET['rowstart'].", $items_per_page"

);

<?php

 

 

$items_per_page = 12;

 

 

if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { 

$_GET['rowstart'] = 0; 

}

 

$rows = dbcount("(*)", DB_NEWS," news_draft='0' AND news_cat=25"); 

//opentable("");

 

//$result = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC LIMIT 0,4");

$result = dbquery(

"SELECT * FROM ".DB_NEWS." 

WHERE news_draft='0' AND news_cat=25 ORDER BY news_datestamp DESC 

LIMIT ".$_GET['rowstart'].", $items_per_page"

);

result = dbquery(

			"SELECT tn.*, tc.*, tu.user_id, tu.user_name, tu.user_status FROM ".DB_NEWS." tn

			LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id

			LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id

			WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")  AND news_draft='0'

			ORDER BY news_sticky DESC, news_datestamp DESC LIMIT ".$_GET['rowstart'].",$items_per_page"

		);

AND news_cat='KATEGORIJOS ID'