Hello Guys
I have following code, sorry it's pretty big for posting, i want to split the output into 2 colomns, been trying almost all still can't get it working here the link, with this code online http://funzz.cjb.net/itfaq/kbase.php -------------------------- <? include "mainfile.php"; $connection = mysql_connect ("127.0.0.1", "*****", "****"); if ($connection == false){ echo mysql_errno().": ".mysql_error(); exit; } $query = "select topicid,topicname from nuke_topics order by topicname"; $result = mysql_db_query ("postnuke", $query); if ($result){ echo "<table border=1>"; $numOfRows = mysql_num_rows ($result); for ($i = 0; $i < $numOfRows; $i++){ $topicid = mysql_result ($result, $i, "topicid"); $topicname = mysql_result ($result, $i, "topicname"); $result1 = mysql_query("select time from nuke_stories where topic=$topicid"); $counter=mysql_num_rows($result1); preg_match ("/([A-Z])/i", $topicname); $letter=$topicname[0]; if($lastletter!=$letter)echo "<tr><td><font size=5><b>$letter</b></font></td></tr>"; echo "<tr><td><a href=search.php?query=&topic=$topicid>$topicname </a> (<b>$counter</b>) </td></tr>"; $lastletter=$letter; } echo "</table>"; } else{ echo mysql_errno().": ".mysql_error()."<BR>"; } mysql_close (); include "footer.php"; ?> ---------- Thank You very much, in advance Have a nice day :-) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]