<?php



$result = dbquery("SELECT user_name, user_id FROM ".DB_USERS." ORDER BY user_name ASC LIMIT 20");



echo "<table cellpadding='0' cellspacing='0' width='100%' border='1'>\n<tr>";

echo "<td><b>User Name</b></td>\n";

echo "<td><b>User ID</b></td>\n</tr>\n";



while ($data = dbarray($result))

{

echo "<tr>\n";

echo "<td>".$data['user_name']."</td>\n";

echo "<td>".$data['user_id']."</td>\n";

echo "</tr>";

}



echo "</table>";



?>

openside("Articles Menu");



// Uncomment the 1st Query and Comment the 2nd Query to show all articles(not from particular category)

//$result = dbquery("SELECT article_id, article_subject FROM ".DB_ARTICLES." ORDER BY article_subject ASC LIMIT 25");



$result = dbquery("SELECT article_id, article_subject FROM ".DB_ARTICLES." where article_cat=3 ORDER BY article_subject ASC LIMIT 25");

// Remember the Limit is set to 25. You can Increase it.



echo "<table cellpadding='0' cellspacing='0' width='100%' border='0'>\n<tr>\n";



// Must start with 3, Cannot start with 0 because at 1 it will give 0.5 which is 0

$i=3;



while ($data = dbarray($result))

{

echo "<td>» <a href='".BASEDIR."articles.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a></td>\n";



if ($i % 2 == 0)

{

echo "</tr>\n<tr>\n";

}

$i++;



}



echo "</tr>\n</table>";



closeside();

<?php



$sortby = ($_GET['sortby'] == "" ? "" : "WHERE article_subject LIKE '".stripinput($_GET['sortby'])."%'");



$result = dbquery("SELECT article_id, article_subject FROM ".DB_ARTICLES." ".$sortby." ORDER BY article_subject ASC LIMIT 25");



while ($data = dbarray($result))

{

echo "» <a href='".BASEDIR."articles.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a><br />\n";

}



$search = array(

		"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R",

		"S","T","U","V","W","X","Y","Z","0","1","2","3","4","5","6","7","8","9"

);



echo "<div class='pagenav' align='center'>";

for ($i = 0; $i < 36 != ""; $i++) {



echo "<a href='".FUSION_SELF."?page_id=".stripinput($_GET['page_id'])."&amp;sortby=".$search[$i]."'>".$search[$i]."</a>";

	}

echo "</div>";

echo "<a href='".FUSION_SELF."?page_id=".stripinput($_GET['page_id'])."'>Show All</a>";



?>

<?php



$sortby = ($_GET['sortby'] == "" ? "" : "WHERE article_subject LIKE '".stripinput($_GET['sortby'])."%'");



$result = dbquery("SELECT article_id, article_subject FROM ".DB_ARTICLES." ".$sortby." ORDER BY article_subject ASC LIMIT 25");



$count = 1;



while ($data = dbarray($result))

{

echo $count.". <a href='".BASEDIR."articles.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a><br />\n";

$count++;

}



$search = array(

		"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R",

		"S","T","U","V","W","X","Y","Z","0","1","2","3","4","5","6","7","8","9"

);



$br = 0;



echo "<div class='pagenav' align='center'>";

for ($i = 0; $i < 36 != ""; $i++) {

echo "<a href='".FUSION_SELF."?page_id=".stripinput($_GET['page_id'])."&amp;sortby=".$search[$i]."'>".$search[$i]."</a>";

if ($br == 17) { echo "<br /><br />"; }

$br++;

	}

echo "</div>";

echo "<a href='".FUSION_SELF."?page_id=".stripinput($_GET['page_id'])."'>Show All</a>";



?>