[RELEASE] Show category list on non vb pages

Here is another one. This one will display a list of categories on a non vb page;

See it in action here:
http://www.extremeforums.com/include...rylist.inc.php

<?php
require("/full/path/to/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "SELECT * FROM category ORDER BY title ASC";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;°
<A HREF=\"http://www.extremeforums.com/forums/index.php?categoryid=$latest_array[categoryid]\">$latest_array[title]</A></FONT><BR>";
}
 
?>

Edit the echo statement as you see fit

~Chris

[Edited by TechTalk on 08-10-2000 at 05:33 PM]

eva - in your inc file, make sure you reference the full path to the config.php, not just admin/config.php

And this doesn't even use forums, so I'm not exactly sure whatcha mean...

okay i think forgot to change the path ? ...with forums i was meant to say that for this thread http://www.vbulletin.com/forum/showt...?threadid=2283

Somewhere in the WHERE clause, add:

AND forumid<>#

where # is the number of the forum you want to exclude.

thanks i will give it a try and let you everyone know

well finally got it to work... http://animeboards.net/forums/showforumlist.php3 thanks

What about showing the list on ANOTHER SERVER?
it will be great , I'm not an expert but I think this can be done using javascript.

Essam - just replace $servername with "123.456.78.90"

Where 123.456.78.90 is the IP of the server you want to connect to. (Also, note the quotes)

Thank you so much,

This can be done with any hack? like top xxx topics?

Hi!
Can you make a little bit modify to let the result with
how many threads like this:

Category xx (230)
Category yy (300)
Category zz (20)

Originally posted by jameshsi
Hi!
Can you make a little bit modify to let the result with
how many threads like this:

Category xx (230)
Category yy (300)
Category zz (20)

I figure out, and paste here in case someone needs it:
<?php

require("/path/to/your/admin/config.php3");
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$query = "SELECT * FROM category ";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
$countid = $latest_array[categoryid] ;
$q1 = "select * from forum where categoryid=$countid";
$howmany = mysql_query($q1,$db);
$counter="0";
while ($count_array = mysql_fetch_array($howmany)) {
$counter = $counter + $count_array[threadcount];
}
echo "<FONT SIZE=\"1\" FACE=\"Arial\">??
<A HREF=\"http://yourdomain/forum/index.php3?categoryid=$latest_array[categoryid]\">$latest_array[title]</A>($counter)</FONT><BR>";
}

?>



Since I am a newbie on PHP coding, please let me know if you know there is a better way to do this.