news module: article.php

Site Admin Joined: Aug 22, 2007 Posts: 1775

hey guys!

how can i display the last articles from the news catagory in the article.php. i have take lines from the topics module (index.php) and set it under the line of themearticle($aaid, ...);. i can dislay atm the latest articles of the site but not the latest articles of the news category. sorry for the bad code but i'm little bit confused on it Smile

Code:

OpenTable();


$sql01 = 'SELECT sid, catid, title FROM ' . $prefix . '_stories WHERE catid=\'' . $catid . '\' ORDER BY sid DESC LIMIT 1,4';


      $result4 = $db->sql_query($sql01);


      $num = $db->sql_numrows($result4);


      if ($num != 0) {


         while ($row4 = $db->sql_fetchrow($result4)) {


            $sid = intval($row4['sid']);


            $catid = intval($row4['catid']);


            $title = stripslashes(check_html($row4['title'], 'nohtml'));





         echo ''.$topictext.' &raquo; <a href="modules.php?name=News&amp;file=article&amp;sid='. $sid .'">'. $title .'</a><br />';         


         }


         } else {


         echo '<i>no articles found!</i>';         


         }


CloseTable();

Posted: Tue Sep 07, 2010 6:24 pm

i have found the solution *gg*

i must change the the sql01 call, only. here the changed line:

Code:

$sql01 = 'SELECT sid, catid, title, topic FROM ' . $prefix . '_stories WHERE topic=\'' . $topic . '\' ORDER BY sid DESC LIMIT 1,4';

Posted: Tue Sep 07, 2010 7:50 pm

how can i add this to my story_page? i want put this sql-call between hometext and bodytext. any ideas?