Puting values on a table

[leetcrew]

$sql = "SELECT * FROM `" . $prefix . "names";
$retid_temp = $db->buffered_db_query($sql)
while ($row_temp = $db->fetch_array($retid_temp))
{
   printf ("%s", $row_temp[names] )

}

How do i put the values on a table just like this?

http://58.69.205.80/temp/table.html

thanks

[vaaaska]

leetcrew wrote:

How do i put the values on a table just like this?

This is messy but you'll get the idea...it just loops out the rows

<table>
<?php
while ($row_temp = $db->fetch_array($retid_temp)) 
{
?>
<tr>
<td><?php print $row_temp[prefix]; ?></td>
<td><?php print $row_temp[name]; ?></td>
<td><?php print $row_temp[last_name]; ?></td>
</tr>
<?php } ?>
</table>

[leetcrew]

thanks but what i mean is i am going to print names. the output should be like this

leetcrew            vaaaska     john smith
john forward     scooby        popeye

[onno182]

leetcrew wrote:

thanks but what i mean is i am going to print names. the output should be like this

leetcrew            vaaaska     john smith
john forward     scooby        popeye

Using tabs and newlines you mean?

[leetcrew]

excactly like this
http://58.69.205.80/temp/table.html

<table border="1">
	<tr>
		<td colspan="3">My favorite fruits</td>
	</tr>
	<tr>
		<td>Apple
		<td>Banana
		<td>Pomelo
	</tr>

<tr>
	<td>Durian
	<td>Orange
	<td>Ponkan
</tr>


<tr>
	<td>Green Apple
	<td>Grapes
	<td>Strawberry
</tr>


<tr>
	<td>n...
	<td>n...
	<td>n...
</tr>

</table>

[toxic_brain]

( database connection....)
<table border="1">

<?php 
$sql	=	"SELECT * FROM your_table"	;
$result	=	mysql_query($sql)				;
$row	=	mysql_fetch_object($result)		;
while(1)
{
echo '<tr>'	;
	for($i=1	;	$i	<=3	;	$i++)
	{
		echo "<td> ". $row->firstname	.	'</td>'	;
		$row	=	mysql_fetch_object($result)		;		
	}
echo '</tr>'	;
	if (empty($row))	break;
}
?>

</table>