[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]

well that worked but it showed all my private categories as well... since i don't know php i borrowed examples from other code i have copied and did this

<?php 

require("/home/usr1/www.animeboards.net/htdocs/forums/admin/config.php"); 
$db=mysql_connect($servername,$dbusername,$dbpassword); 
mysql_select_db($dbname); 
$query = "SELECT * FROM category where categoryid=1 or categoryid=2 or categoryid=3 or categoryid=4 or categoryid=5 or categoryid=6 or categoryid=7 or categoryid=8 or categoryid=9 or categoryid=10 or categoryid=11 ORDER BY displayorder, title ASC"; 
$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://animeboards.net/forums/index.php?categoryid=$latest_array[categoryid]\">$latest_array[title]</A> ($counter)</FONT><BR>"; 
} 

?>

so i specified each category i wanted to show with 'or categoryid=2' in the query also this displays them in the order you set them in the control panel

i just have no use for displaying this though

[Edited by eva2000 on 09-05-2000 at 05:56 AM]

Originally posted by eva2000
well that worked but it showed all my private categories as well... since i don't know php i .....

mysql_select_db($dbname);
$query = "SELECT * FROM category where categoryid=1 or categoryid=2 or categoryid=3 or categoryid=4 or categoryid=5 or categoryid=6 or categoryid=7 or categoryid=8 or categoryid=9 or categoryid=10 or categoryid=11 ORDER BY displayorder, title ASC";
.................]\">$latest_array[title]</A> ($counter)</FONT><BR>";
}

?>[/code] so i specified each category i wanted to show with 'or categoryid=2' in the query also this displays them in the order you set them in the control panel

i just have no use for displaying this though

[Edited by eva2000 on 09-05-2000 at 05:56 AM]

You can use :
where categoryid<>'xx'
xx means the categoryid that you don't want to display.

thanks i am learning always wondered what categoryid<> meant