Specific Categories Block

New Member Joined: Mar 01, 2004 Posts: 8

Hi,

I wanna make a block that will contain the last 10 titles of a specific category. If for example i have in my news module a category named Cinema i wanna make a block that will contain the last 10 post i will make about cinema....
I posted the same idea at Karakas Forum and he gave me that link:

http://www.ravenphpscripts.com/download-file-78.html

with a suggestion to adapt it to my situation. The think is that i tried some thinks but without success...

Posted: Mon May 24, 2004 3:13 pm

Here's something similar that might help:

Code:

<?php





if (eregi("block-Select_Stories.php", $_SERVER['PHP_SELF'])) {


    Header("Location: index.php");


    die();


}





global $prefix, $db, $user, $cookie;


$mytopic = "1";   


$a = 1;


$row = $db->sql_fetchrow($db->sql_query("SELECT sid, title FROM ".$prefix."_stories WHERE topic='$mytopic' ORDER BY sid DESC LIMIT 0,10"));


while ($row = $db->sql_fetchrow($result)) {


    $r_options = "";


    if (isset($cookie[4])) { $r_options .= "&amp;mode=$cookie[4]"; }


    if (isset($cookie[5])) { $r_options .= "&amp;order=$cookie[5]"; }


    if (isset($cookie[6])) { $r_options .= "&amp;thold=$cookie[6]"; }


    $content .= "<strong><big>&middot;</big></strong>&nbsp;$a: <a href=\"modules.php?name=News&amp;file=article&amp;sid=$row[sid]$r_options\">$row[title]</a><br>";


    $a++;


}


$content .= "<br><center>[ <a href=\"article-topic-.html$mytopic\">"._MORENEWS."</a> ]</center>";





?>

Change the 1 in $mytopic = "1"; to the topic number of your choice.

Posted: Mon May 24, 2004 6:09 pm

Works Fine !
You are simple the BEST!!!
Thanks

Posted: Tue Aug 03, 2004 1:03 am

I noticed that this script that Chatserv have posted in the past...
dont shows the last article from every categorie...
But i cant figure out what to change so this block will show the last article too...any ideas?