How to display contents from mysql database in Order?

[ashfaqbinnazar]

This is a part of a Social community that i am going to build in php.
This is same as the My friend list frame in Orkut,facebook etc.
how can i display the content in mysql database order by 3 colums and 3 rows.
Please help me...
Thanks in advance.
here is my code of my friends frame
userreg is the table name
id<>$id means-select all id of users except the logged persons id.

My Friends</h3>
        <table width="29%"  height="277" border="1">
        <?php $result= mysql_query("SELECT * FROM userreg where id<>'$id'")
				or die(mysql_error());  
  				$count3=mysql_num_rows($result);
				while($count3>0)
				{
				$count3--;
				$row4= mysql_fetch_array($result);
				$y=$row4['username']; 
				$id=$row4['id']; 
				$toid=$id;
				?>
               <tr>
                 <td height="89">&nbsp;</td>
                 <td>&nbsp;</td>
                 <td>&nbsp;</td>
               </tr>
               <tr>
                 <td height="89">&nbsp;</td>
                 <td>&nbsp;</td>
                 <td>&nbsp;</td>
               </tr>
               <tr>
			<td width="35%" height="89">
            <?php 
			echo "<a href='scrapbook.php?toid=$toid'>$y</a>";
			?>			</td>
            <td width="33%">&nbsp;</td>
            <td width="32%">&nbsp;</td>
          </tr>
          <?php }?>
</table>

[chathura86]

you can use mysql ORDER BY to sort the result set

search for MySQL ORDER BY in google to get some idea about it

Regards

[ashfaqbinnazar]

Thanks alot for the information..