Creating a Block that lists active site Topics

Exodus · Beginner Joined: Oct 02, 2004 Posts: 18

Hello, I'm trying to create a Block called "Main Menu" that lists site topics (not forum topics). For instance my site is about unknown/paranormal happenings so I want the "Main Menu" Block to list my topics such as
Ghosts & Huantings
Aliens & UFO's
and so on...........

and when a visitor one (lets say Aliens & UFO's) , then the center block will pull up that topic.

If anyone can help me figure this out I would appreciate it very much!

Thanks -
Exodus

AdBot

dari

create a block file called block-Topics.php and put this in it:

PHP: ›

<?php



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

    Header("Location: index.php");

}



global $db,$prefix;



$result = $db->sql_query("SELECT topicid,topictext FROM ".$prefix."_topics");



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

        $content .= "<a href=\"article-topic-.html".$row['topicid']."\">".$row['topictext']."</a><br>";

}

?>

_________________

Exodus · Beginner Joined: Oct 02, 2004 Posts: 18

That is almost perfect! Thank you so much! Would it be hard to make the list spread out a little with bullets in front of them (like on the block-modules)?

Thanks!!

Eric -

-- One more thing, I just noticed that each Topic link dosent seem to know which topic number corresponds with it, so I get a "not found" type error when I click on one.

dari

PHP: ›

<?php



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

    Header("Location: index.html");

}



global $db,$prefix;



$result = $db->sql_query("SELECT topicid,topictext FROM ".$prefix."_topics");



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

        $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"modules.php?name=News&amp;new_topic=".$row['topicid']."\">".$row['topictext']."</a><br>";

}

?>

_________________

dari · Last edited by dari on Mon Oct 18, 2004 8:51 am; edited 1 time in total

sorry for the other problem you were having, the Googletap f*cked up the URL in the href. my post above has it fixed.
_________________

Exodus · Beginner Joined: Oct 02, 2004 Posts: 18

Update -

I fixed the link issue, they work GREAT, the only thing I would like to change is the line spacing and add bullets. THANK YOU!

dari · Last edited by dari on Mon Oct 18, 2004 8:32 am; edited 1 time in total

see my post after your "That's almost perfect" post. It has bullets.
_________________

Exodus · Beginner Joined: Oct 02, 2004 Posts: 18

-------------
--------------
Sorry I didnt realized the code fixed both problems! You are great! I've been going crazy over this for a week!

Thanks again!
Eric

dari

No problem, glad to be of service Smile

_________________