Output to multiple HTML Columns

[artbones]

I am trying to output from a MySQL Database to PHP and I need the information to be span several columns rather than spill down the page.

ex:

          a              |               d                  |                 g
          b              |               e                  |                 h
          c               |               f                   |                  i

rather than:

a
b
c
d
e
f
g
h
i

I am assuming that I should use the count() operator in some fashion, but my brain isn't working today. Thanks for your help.:p

[jpmoriarty]

theres no need to anything so complicated as count().

<table border=1 cellspacing=1 cellpadding=1>
<?
  $count=1;
  $sql = "...";
  $result = mysql_query($result);
  $num_results = mysql_num_rows($result);
  for($i=0;$i<$num_results;$i++)
  {
    $row = mysql_fetch_array($result);
    if($count==1)
      echo "<tr>"
    echo "<td>".$row['letter']."</td>";
    if($count==3)
    {
      echo "</tr>";
      $count = 0;
    }
    $count++;
  }
?>
</table>

[artbones]

I tried something like this, and I couldn't get it to work. 🙁

I think I found out why. When you copy and paste from this board miscellaneous underscores are added (_) throughout your code. They are invisible though. How bizaar...

[artbones]

My final code works great. Thanks for your help. In case anyone else is searching for the same thing here is what worked for me:

<?

if (!($result = mysql_db_query("$DB","select r_id, catref, filename, linkname, description, active from report where catref=5 and active=1"))) {

DisplayErrMsg(sprintf("internal error %d:%s\n",
	mysql_errno(), mysql_error()));
return 0 ;

}

echo"<table border=1 cellspacing=1 cellpadding=1>";

$count=1;
$sql="...";

$num_results=mysql_num_rows($result);

for($i=0; $i<$num_results; $i++){
	$row = mysql_fetch_array($result);

if($count==1){
	echo"<tr>";
	echo"<td>".$row['linkname']."</td>";
}
if($count==2){
	//echo"<tr>";
	echo"<td>".$row['linkname']."</td>";
}
if($count==3){
	//echo"<tr>";
	echo"<td>".$row['linkname']."</td>";
	echo"</tr>";
	$count=0;
}

$count++;
}

?>

</table>

[jclout]

Try this:

<?php
echo "<table width=\"100%\" border=\"1\" bordercolor=\"#FFFFFF\">"; 
    $j = 0; 
    $rownum = 0;     

    $result = mysql_query($query); 
    if (($result = @ mysql_query ($query, $connection))){ 
        while ($row = mysql_fetch_array($result)){ 
            if($j == $rownum) { 
                echo "<tr>"; 
                $rownum += 2; //<------- REPLACE 2 WITH NUMBER OF RECORDS PER ROW 
            } 
            echo "<td>";
			echo mysql_result($result,$i,letter);
			echo "</td>"; 
        ++$j;
	    } 
        if($j == $rownum) { 
            echo "</tr>"; 
        } 
    } 
    echo "</table>";
?>

[cgraz]

all these ways are pretty similar, but here's how I do it

$i = 1; 
$cols = 3; 

echo "<table border='1' width='100%'><tr>";

while ($row=mysql_fetch_array($query)) {
    if ($i > $cols) {
       echo "</tr><tr>";
       echo "<td>" . $row["linkname"] . "</td>";
       $i = 2;
    } else {
       echo "<td>" . $row["linkname"] . "</td>";
       $i++;
    }
}
echo "</table>";

Cgraz

[jebster]

OMG I was wondering this! Thank you all! 😃