[PHP] spliting results into 2 colomns

[Daniel Harik]

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]