php to print to html table

Anon

hello anyone that can help me, i am trying to print my results from a query to a table limited to two rows and two collumns, so I want to print the first four results to the table , i am having lots of trouble since i am fairly new to php and programming, I got it to print to the cells but it repeats the same result to each row, plus how do i limit it too rows since it stretches the page out of proportion with too much display any help would be greatly appreciated, here is the snippet i am working with,

						<?

						print "<table border=\"0\" cellpadding=\"10\" cellspacing=\"0\" width=\"100%\" height=\"100%\">";

								while ($a_row=mysql_fetch_array($result))
								{
								print"<tr>";
								for ($i=1;$i<=2;$i++)
								{
								print"<td><span class=\"descr\">

								    $i.$a_row[bus_name] \n<BR>
								    $a_row[fname] $a_row[lname]\n<BR>
								</span></td>";
								}
								print"</tr>";
								}
						print"</table>";

							?>

bart_coppens

I think your problem lies by your query when I hear your problem. Coul I/we see the query?
You can add LIMIT 0,3 to you query, to show only the first four. Or, if I understand your question completely, you could try this:
for ($i=1; $i=2; $i++)
{
$a_row = mysql_fetch_array($result);
print"<tr>";
for ($i=1;$i<=2;$i++)
{
print"<td><span class=\"descr\">
$i.$a_row[bus_name] \n<BR>
$a_row[fname] $a_row[lname]\n<BR>
</span></td>";
}
print"</tr>";
}
print"</table>";

steve3000

thanks for the help, the LIMIT helped the appearance, since i still could not get the four records to appear in the four cells i limited it to two and it looks very neat thanks a lot, i would still like to see four records, whats happening is i can't figure out how to index the results or something , i want it to print to the cells like this

1.Harry Jones 2.Jon Rollings
1234 highway rd 3445 apple tree rd
wlmsc, NY 14222 willians, NC 23333

3.Mary Williams 4.Peter Durring
4444 red stonw 3333 wing way rd
juno, AK 2222 Buffalo, NY,22333
instead 1. and 2. repeat the same record as well as 3 and four. I tried your sniippet and got and endless loop, thanks again for help.

here is the table i want to print to<tr>

					<tr>				<td><span class="descr"><b><br>
	</b><br>
</span></td>
<td><span class="descr"><b><br>
	</b><br>
</span></td>
</tr>
<tr>
<td><span class="descr"><b><br>
	</b><br>
</span></td>
    td><span class="descr"><b><br>
        </b><br>
</span></td>
</tr>				 here is the query i am running

$query = "SELECT * from dealers
Where (zip >= ($zp-$incr) and zip <= ($zp+$incr))
Order by bus_name ASC LIMIT 0,2";
$result = mysql_query( $query, $link );
$a_row=mysql_fetch_array($result);