help for creating a dynamic table

[mungra]

Hi!! well i wanted to have a dynamic table consisting of 3 columns .

Instead i am having a table consisting of only one column

my codes are below
<?php

//connection stuffs

$username="vinay";
$db="movedb";
$passwrd="vinay";
mysql_connect(localhost,$username,$passwrd);
@mysql_select_db($db)or die("cannot connect to db");

$query="select * from user";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo"<table border =1 align=center>";
$cols=3;
for($i=0;$i<$num;$i++)

{
echo"<tr>";

echo"<td>".mysql_result($result,$i,"Name")."</td>";

echo "</tr>";
}

echo"</table>";

mysql_close();
?>

can anyone help me tell me how to create a a dynamic table consisting of 3 columns instead of 1.

regards
mungra

[rincewind456]

Are you retrieving 3 columns of data with this query or do you want the names to appear in 3 columns side by side?

[mungra]

i want to have the names to appear side by side

Name1 Name2 Name3
Name4 Name5 Name6
...

i.e a table consisting of 3 cols

[computerFrEEk]

this should do the trick:

<?php

//connection stuffs

$username="vinay";
$db="movedb";
$passwrd="vinay";
mysql_connect(localhost,$username,$passwrd);
@mysql_select_db($db)or die("cannot connect to db");

$query="select * from user";
$result=mysql_query($query);

$cols=3;
$rows=mysql_numrows($result)/$cols;

echo "<table border =1 align=center>";
$c=0;
for($i=0;$i<$rows;$i++){
	echo "<tr>";
	for($x=1;$x<=$cols;$x++){
		echo "<td>".mysql_result($result,$c,"Name")."</td>";
		$c++;
	}
	echo "</tr>";
}

echo "</table>";

mysql_close();
?>