tables (multi column)

Bobs

I want to display a table of links on my page. The table contains two cells in each row.
The rows of my database contain the name of the link its url and ID.
I want to display the first link in the first cell of the first row, the second link in the second cell of the first row, the third link in the first cell of the second row and so on.
Can anybody help?

rIkLuNd

<?php

// mysql connection
mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db);

// query
$result = mysql_query("SELECT * FROM table") or die(mysql_error());

echo "<table border=\"0\">\n";

while($row = mysql_fetch_array($result,1))
{
   echo "<tr>\n";
   echo "<td>" . $row['id'] . ". " . $row['url'] . "</td>\n";
   echo "</tr>\n";
}

echo "</table>\n";

?>

Bobs

I want to modify my code below so that the first record of information from my DB is displayed in the first cell of the first row of my table, the second record in the second cell of the first row, the third record in the the first cell of the second row of my table and so on

 <?php
# insert_it.php
# include file
include ("Connections/test_holding_inc.php");
$sql="select * from slides";

$mysql_result=mysql_query($sql,$connection);
$num_rows=mysql_num_rows($mysql_result);
if ( $num_rows == 0 ) {
echo"<tr><td colspan =\"2\" align=\"center\"><font color=\"red\">Sorry there are no slides at present</font></td></tr>";
} else {
while ($row=mysql_fetch_array($mysql_result))
{
$name=$row["name"];
$url1=$row["url1"];
echo
"<tr align=\"center\"><td><A HREF = '$url1'> $name</A></td></tr>";
}}
 # end else
mysql_close($connection);
?>

rIkLuNd

try this:

$itemsPerRow = 2;
$item =  1;

echo "<table>\n";

while ($row=mysql_fetch_array($mysql_result))
{
   if(($item % $itemsPerRow) == 1)
   echo "<tr>\n";

   $name=$row["name"];
   $url1=$row["url1"];
   echo "<td><A HREF = '$url1'> $name</A></td>\n";

   if(($item % $itemsPerRow) == 0)
   echo "</tr>\n";

   $item++;
}

echo "</table>\n";