Help - How to have 2 columns???

[edhan]

Hi

Being new to programming, I wonder if someone can help to advice how I can create 2 columns for displaying users.

I am thinking of splitting it to 2 or 4 columns so that it will reduce the height of display in a single column.

Hope someone can give some help on this. Thanks!

Here is my current code:

<?php
$query1="SELECT `username` FROM `record` where `active` ='1' order by `userid` DESC LIMIT 100";
$result1=mysql_query($query1);

$num=mysql_numrows($result1);



echo "<b><center>Last 100 Members</center></b><br>";

if ($num>101) {
$to=1;
}else{
$to=$num;
}

$i=0;
while ($i < $to) {

$loginname=mysql_result($result1,$i,"username");

echo "<a href='$siteurl/$loginname.html'>$loginname</a><br>";

$i++;
}

?>

[wige]

I think the following should work, I am assuming here you would use a table...

PHP Code:

<?php
$query1="SELECT `username` FROM `record` where `active` ='1' order by `userid` DESC LIMIT 100";
$result1=mysql_query($query1);

$num=mysql_numrows($result1);

echo "<b><center>Last 100 Members</center></b><br>";

if ($num>101) {
$to=1; // This should be 100, not 1 correct?
}else{
$to=$num;
}

$i=1;
if ($to > 10) { // Only show two colums if more than 10 entries are to be displayed - in case you want that ability
   $midpoint = ($to + 0.5) / 2; // This ensures the division rounds up, this will make the first column longer for odd numbers
}
echo '<table><tr><td>';
while ($i <= $to) {

   $loginname=mysql_result($result1,$i,"username");

   echo "<a href='$siteurl/$loginname.html'>$loginname</a><br>";
   if ($i == $midpoint) echo '</td><td>'; // Switch to column two, if column one is full
   $i++;
}
echo '</td></tr></table>';
?>

[fahadp]

Using tables can be a good approach or you can organise listing by using XHTML. If you use XHTML and css then you dont need to worry about laying down members in php code, css will take care of it.

Any how i am going to provide you with a code that uses table

PHP Code:

 
<?php
$query1="SELECT `username` FROM `record` where `active` ='1' order by `userid` DESC LIMIT 100";
$result1=mysql_query($query1);
$num=mysql_numrows($result1);
 
echo "<b><center>Last 100 Members</center></b><br>";
/* added by Fahad Pervaiz */
echo "<table><tr>";
$count=1;
while ($row = mysql_fetch_assoc($result1)) 
{
 if($count==5)//5 colums per row
 {
  //add a new ROW
  echo "</tr><tr>";
  $intc=1;
 }
 
 echo "<td>".$row['username']."</td>";
 $count++;
}
/* end Fahad Pervaiz */
?>

[edhan]

Thanks to both of you, now it is working fine.

Appreciate your help.