1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

 $result = dbquery("SELECT * FROM ".DB_NEWS." 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_datestamp DESC LIMIT 0,10" );
 
      $hirek = "";
      while ($data = dbarray($result)) {
         $hirek[] = $data['news_subject'];
         
      }
 
      echo "<hr />";
 
     
      $cikkek = "";
      $result = dbquery(
         "SELECT ta.*, tac.*
         FROM ".DB_ARTICLES." ta 
         INNER JOIN ".DB_ARTICLE_CATS." tac ON ta.article_cat=tac.article_cat_id
         WHERE ".groupaccess('article_cat_access')." AND article_draft='0'
         ORDER BY article_datestamp DESC LIMIT 0,10"
      );
 
      
 
      
      while ($data = dbarray($result)) {
         $cikkek[] = $data['article_subject'];
         
      }
      
      echo "<table width='100%' border='1' cellspacing='0' cellpadding='0'>";
         echo "<tr><td class='tbl2'>Hírekk</td><td class='tbl2'>Cikkek</td></tr>";
       for ($i=0; $i<0; $i++) {
         echo "<tr><td>".$hirek[$i]."</td><td>".$cikkek[$i]."</td></tr>";
      }
      echo "</table>";