Mysql_query and Table Columns

[Wil_Hatfield]

Hello all,

I want to retrieve the last 20 entries to a database and create a two column table from them. The problem isn't the retrieval but what to do with the while statement to get the columns (cells) formatted two items per row.

Yes I understand this is probably something elementary and that is the reason I am posting it in 'Newbies'.

The easy part:
select pnumber from products where newprod='yes' order by prod_id desc limit 20

The desired output

<tr><td>{1st pnumber}</td>><td>{2nd pnumber}</td></tr>
<tr><td>{3rd pnumber}</td>><td>{4th pnumber}</td></tr>
etc.......

Line listings would be so much easier.... ugh.

Thanks in advance.......

Wil

[cahva]

Try something like this:

<?php
$query="select pnumber from products where newprod='yes' order by prod_id desc limit 20";
$result=mysql_query($query);

$i=0;
while ($row=mysql_fetch_array($result))
{
	if ($i==0) { echo '<tr>'; }
	echo "<td>".$row['pnumber']."</td>";

if ($i==1) { echo '</tr>'; $i=-1; }
$i++;
}	
?>

[Wil_Hatfield]

Worked like a charm.... Thanks.