spliting results into 2 colomns
| From: | Daniel Harik | Date: | Wed, 31 Oct 2001 18:44:08 +0000 |
| Subject: | spliting results into 2 colomns | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-72992@lists.php.net to get a copy of this message | ||
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 :-)