mysql output data

corruption

i'm creating a page that lists all of the people in a group which currently is up HERE
I want the page to display with three columns because as the table gets populated there could be upto 100 or so names. I wanted to know what i would need to change in the following. I'm hoping that i don't have to query each row seperately.

<?
include '../connect.php';
session_start();

if(( isset( $_SESSION['fname'] )) || ( isset( $_SESSION['lname'])))
{
  echo 'Welcome'." ".$_SESSION['fname'];
  }
  else
  {
  header('location: index.html');
  }
//script to display the list of people
$sql    =    "SELECT * FROM brothers ORDER BY lname ASC";
$result    =    mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result) > 0)
    {
    ?>
    <body text="#FFFF00" bgcolor="#000000" alink="#FFFF00" vlink="#FFFF99" link="#FFFF00">

<table width="800px" cols="3" align="center">
<tr>
<?php 
while($row = mysql_fetch_array($result)) 
{
    echo "<td width=125px align=center>";
    echo "<a href=profile.php?id=".$row['id'].">";
	echo $row['fname']." ".$row['lname'];

    echo "</a>";
	echo "</td>";
}
?>
</tr>
</table>

<?php 
} 
    else
    {
    echo "No rows returned!";
    }

mourisj

What you do is putting all table rows in one line, although you defined a 3-column-table.

You have to nest 2 loops:
First, your while loop as you did;
Then, inside this loop, a second loop incrementing from 1 through 3, making somthing like:

insert a <tr> if 1
insert a <td>[DATA]</td> if 1, 2 or 3
insert a </tr> if 3
reset to 1

I hope you understand what I mean, but I am am too tired tonight to do the complete coding of this.

Note: Remove your <tr> before and the </tr> behind the first loop!

Have a nice day,

JJ Mouris