Displaying Columbs.

[Rakim]

Hi everyone,

can someone please help me here i am trying to display my results from my MySQL database in collums in a table other than in rows can anyone give me the "echo" and "print" codes todo this please,

Thanks in advance as usuall whoever does it for me gets a free package at www.icthost.com

[sidney]

somthing like below

 require("connect.php");
$query="SELECT * FROM test";
$sql=mysql_query($query);
while($row=mysql_fetch_assoc($sql))
	{
	foreach($row as $key => $val)
		{
		$store[$key][]=$val;
		}
	}
	echo"<table>";
foreach($store as $vals)
	{
	echo"<tr>";
	foreach($vals as $val)
		{
		echo"<td>".$val."</td>";
		}
	echo"</tr>";
	}
echo"</table>";
 

where do i sign up for my free account