List in 2 or more column

[web_master]

Hi,

how can I list from database in 2 or 3 column...

 

 

<table width="100" border="0" cellspacing="0" cellpadding="0">

<tr>

<td>

 

<?php

$query_return=mysql_query("SELECT * FROM table ORDER BY table_id ASC");

 

while ($request=mysql_fetch_array($query_return)) {

?>

<!-- this table need to listed in 2 or more column -->

<table width="100" border="0" cellspacing="0" cellpadding="0">

 

<tr>

  <td><?print $request['id'];?></td>

  <td><?print $request['work'];?></td>

</tr>

 

<tr>

  <td><?print $request['home'];?></td>

  <td><?print $request['work'];?></td>

</tr>

 

</table>

<? }?>

 

</td>

</tr>

</table>

 

 

 

thanx

[Barand]

not sure what you are trying to achieve. ???

[web_master]

I want to list the table in a 2 or 3 cols...

 

Maybe its better like this:

 

<table width="100" border="0" cellspacing="0" cellpadding="0">

<?php

$query_return=mysql_query("SELECT * FROM table ORDER BY table_id ASC");

 

  while ($request=mysql_fetch_array($query_return)) {

?>

<tr>

 

<td><table... $id1 .../table></td>

<td><table... $id2 .../table></td>

<td><table... $id3 .../table></td>

 

</tr>

 

<tr>

 

<td><table... $id4 .../table></td>

<td><table... $id5 .../table></td>

<td><table... $id6 .../table></td>

 

</tr>

<?php } ?>

</table>

[Barand]

Example code

<?php

// author: Barand

include 'db.php';         // connection stuff

define ("NUMCOLS",3);

$res = mysql_query("SELECT col1, col2 FROM mytable");

$count = 0;
echo "<TABLE border=1>";
while (list($col1, $col2) = mysql_fetch_row($res)) {

    if ($count % NUMCOLS == 0) echo "<TR>\n";  # new row

    echo "<TD>$col1<br>$col2</TD>\n";
    $count++;

    if ($count % NUMCOLS == 0) echo "</TR>\n";  # end row
}

# end row if not already ended

if ($count % NUMCOLS != 0) {
   while ($count++ % NUMCOLS) echo "<td> </td>";
   echo "</TR>\n";
}
echo "</TABLE>";

?>

[web_master]

Barand, Youre great!

 

thank You!