iGuest 3 Report post Posted February 13, 2005 I need to alphabetize my review section of my forums but I don't want to do it by hand is there an addon to do that like it is on php, i'm trying to do that with pnp...any body know how I do this? Share this post Link to post Share on other sites
iGuest 3 Report post Posted February 13, 2005 I need to alphabetize my review section of my forums but I don't want to do it by hand is there an addon to do that like it is on php, i'm trying to do that with pnp...any body know how I do this? Yes you can do it. Is it a phpbb forum? Check places like http://www.phpbbhacks.com/ or https://www.phpbb.com/ should have a mod of some sort do it otherwise, if you'll bear with me will I check, it should be simple to write something. EDIT: Back, okay if this page isn't a phpBB page and you just want to sort by name use a script like this <?php//connect to database$db_name = "";$table_name = "";$connection = @mysql_connect("localhost", "", "") or die(mysql_error());$db = @mysql_select_db($db_name, $connection) or die(mysql_error());//sql query$sql = "SELECT * FROM $table_name ORDER BY title DESC";$result = @mysql_query($sql, $connection) or die (mysql_error());while ($row = mysql_fetch_arry($result)) {//$id = $id['id'];//$year = $row['year'];//$event = stripslashes($row['event']);//you replace these vars with the ones you want to use$display_block .= "<p><strong>$year</stong><br />$event</p>";}?><html><head><title>Reviews</title></head><body><h1>Reviews</h1><br /><?php echo "$display_block"; ?><br /><br /><p><a href="index.htm">Search Again</a></p></body></html> if it is a phpbb page I have a hack for it too Share this post Link to post Share on other sites
iGuest 3 Report post Posted February 14, 2005 Yeah, it's a phpbb page I'm pretty sure... http://forums.xisto.com/no_longer_exists/ Share this post Link to post Share on other sites
iGuest 3 Report post Posted February 14, 2005 Then let me whip something up quickly.EDIT: Looking it up, it's a phpnuke module. I'll need to see some code. But it should *hopefully* be just a simple "SORT BY $whatever DESC" Share this post Link to post Share on other sites
