row table placement

[rachcakes]

I want to output my data into a three-column table, but I do not understand where to place my HTML tables or if I need additional coding.

With the following example, the results contain duplicates:

	$query = "SELECT * FROM customers"; 
	$result = mysql_query($query);
echo "<table width='600' border='1' cellspacing='4' cellpadding='0'>";
  while ($row = mysql_fetch_array($result))
  {
     extract($row);
echo "	<tr>
		<td>Hi, my name is $name and I'm $age years old.</td>
		<td>Hi, my name is $name and I'm $age years old.</td>
		<td>Hi, my name is $name and I'm $age years old.</td>
	</tr>"; }
echo "</table>";

// Desired Table Format
+--------+--------+--------+
+--------+--------+--------+
+--------+--------+--------+

[crislewis]

It's not clear from your example exactly what you are trying to achieve.

Do you want to out put each record three times on each table row or, possibly more logically, each record once, three per row?

If the first your code should work but watch all the white space in the main echo statment. If the latter, then you need an additional loop to control the output of each column in a row. Remember to handle the situation where the total number of rows is not divisable by 3. You will need code to round off the table properly.