Specific Categories Block

koun · 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:

Only registered users can see links on this board!
Get registered or login to the forums!

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

chatserv · 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 .= "&mode=$cookie[4]"; }
if (isset($cookie[5])) { $r_options .= "&order=$cookie[5]"; }
if (isset($cookie[6])) { $r_options .= "&thold=$cookie[6]"; }
$content .= "<strong><big>·</big></strong> $a: <a href=\"modules.php?name=News&file=article&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.

koun · New Member Joined: Mar 01, 2004 Posts: 8

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

koun · New Member Joined: Mar 01, 2004 Posts: 8

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?