echo fixed width columns from mysql

[aprivate]

Hello,
Im trying to visualize db output in the more convenient way to observe,
but in my code below, when i run it, everything is shifted to the left.

[e-mail] 111 john 10:16:33 Jun 17, 2012

[e-mail] 23 otheruser 10:16:33 Jun 17, 2012

$email=mysql_result($result,$i,"email");
$amount=mysql_result($result,$i,"amount");
$userid=mysql_result($result,$i,"userid");
$date=mysql_result($result,$i,"date");
$remarks=mysql_result($result,$i,"remarks");
echo "<b>$email $amount $userid $date $remarks</b><hr>";

So the question is how to display mysql data in strict
vertical columns without shifting?
should i use printf? or convert it to array?
thank you so much

[NogDog]

Most common way: use HTML tables.

An alternative way: use the PHP [man]strpad/man function.

Another alternative way: use the PHP [man]sprintf/man or [man]printf/man function.

(For the alternatives, you probably want to wrap the output in <pre> tags.)

[aprivate]

can you give me a hint,
how it supposed to look like,
appreciate this

[NogDog]

<?php
$testData = array(
	array(
		'name' => 'John Doe',
		'age'  => 55,
		'rate' => 1.25
	),
	array(
		'name' => 'John Q. Public',
		'age'  => 101,
		'rate' => 21.2345
	)
);
echo "<pre>";
foreach($testData as $data) {
	printf(
		"&#37;-20s%4d%9.3f\n",
		$data['name'],
		$data['age'],
		$data['rate']
	);
}
echo "</pre>";