output in different table columns...

[Xiode]

I was wondering if anyone had any examples on how I could get my output on different columns... Like Instead of it coming out one by one down the page... Place them in a 3 columns....

[dgiberson]

could you maybe explain this a bit more?

do you mean like?
| Col 1  | Col 2  | Col 3 |
| $var1 | $var2 | $var3 |

or

Row 1 | $var 1
Row 2 | $var2
Row 3 | $var3

?

[taith]

assuming you have a database...

[code]
<?
$result=mysql_query("SELECT * FROM table");
$i=0;
echo '<table>';
while($row=mysql_fetch_array($result)){
if($i==0) echo '<tr>';
echo ' <td>'.$row[row1].'</td>';
echo ' <td>'.$row[row2].'</td>';
echo ' <td>'.$row[row3].'</td>';
$i++;
if($i==3){
  $i=0;
  echo '<tr>';
}
}
echo '</table>';
?>
[/code]
something to that effect :-)

[Xiode]

Maybe I am not seeing this in the code..........

I am pulling some things from the DB.. each row will have it's own box.. I want 3 boxes to go across the page then start a new tr....

Something like this

<tr>
  <td> DB ROW 1 </td>
  <td> DB ROW 2 </td>
  <td> DB ROW 3 </td>
</tr>
<tr>
  <td> DB ROW 4 </td>
  <td> DB ROW 5 </td>
  <td> DB ROW 6 </td>
</tr>

[taith]

[code]<?
$result=mysql_query("SELECT * FROM table");
$i=0;
echo '<table>';
while($row=mysql_fetch_array($result)){
if($i==0) echo '<tr>';
echo ' <td>'.$row[columnname].'</td>';
$i++;
if($i==3){
  $i=0;
  echo '<tr>';
}
}
echo '</table>';
?>[/code]

[Xiode]

IS[code] if($i==3){
  $i=0;
  echo '<tr>';[/code]

Suppose to be

[code] if($i==3){
  $i=0;
  echo '</tr>';[/code]

?

:P

[taith]

right... that was my typo lol

[Xiode]

Thanx man...

[taith]

no problem... anytime :-)

[Xiode]

Trust me... I will have quite a bit more :S