Displaying id from 1 column

[viraj]

I have a table having 1 column, ID, having 9 records.
I want to display the records in a table(3 rows and 3 columns) in my php page such that they the first record is in
(1st row,1st coumn) 2nd record is in (1st row,2nd column) 3rd record is in(1st row,3rd column)
4th record is in (2nd row,1st column) and so on.
Plz help me out. Thanks in advance for your usual help.
:mad:

[pyro3k]

pull the info from the database and then loop through the results like below

$sql = "SELECT * FROM your_table_name";
$result = mysql_query( $sql ) or die( mysql_error() );

echo "<table>";
echo "<tr>";

while ( $row = mysql_fetch_array( $result ) ) 
{
         echo "<td>$row['ID']</td>";
}

echo "</tr>";
echo "</table>";

[suntra]

$sql = "SELECT * FROM your_table_name"; 
$result = mysql_query( $sql ) or die( mysql_error() ); 

echo "<table>\n"; 
$intTotal = 0;
while ( $row = mysql_fetch_array( $result ) ) 
{ 
         if($intTotal == 0) {
                  echo "<tr>\n";
         }
         echo "<td>$row['ID']</td>\n"; 
         $intTotal++;
         if(intTotal == 3) {
                  echo "</tr>\n"; 
                  $intTotal = 0;
         }
} 

echo "</table>";