[SOLVED] Show data in table

[steviez]

Hi,

 

I am making some code for a online users box and need to get the results to display horizontally but i cant seem to get it to work. The code below only seems to show the results vertically:

 

<?php
echo "<table width=\"250\" border=\"0\">";
while($online = mysql_fetch_array($online_users)){
echo "<tr>";
echo "<td class=\"sc_text\">".$online['username']."</td>";
echo "</tr>";
echo "<tr>";
echo "<td><img src=\"".$online['profile_picture']."\" border=\"0\" alt=\"\" width=\"250\" height=\"250\" /></td>";
echo "</tr>";
}
echo "</table>";
?>

 

Can someone please point me in the right direction

 

Thanks

[Barand]

sample

<?php
include 'db.php';

define ("NUMCOLS",5);

$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>";

?>

[steviez]

Thanks for this code it works great! How could i get this code to work with pagination?

[Barand]

Just add a LIMIT x,y clause to the end of query

[steviez]

Thanks for all your help