Loops and Presentation

[Anon]

Sorry about the length. I have the following code pulling row from my database. My problem is layout. I already limit the return to 6 items per page...however, I am having trouble putting 3 items on one row and 3 items on the next instead of all on the same row or column. Can anyone help? I've tried everything (I know that is...)

print "<table border=0 cellspacing=0 align=center width=\"85%\"><tr>";

	$limit_str = "LIMIT ". $cur_page * $listings_per_page .",$listings_per_page";
	$result = mysql_query("SELECT * FROM vehicles $limit_str",$link);
	while ($a_row =mysql_fetch_array ($result) )
		{
		//add commas to price
		$a_row[price] = number_format ($a_row[price]);

		print "<td align=center>";			
		print "<a href=\"./carview.php?view=$a_row[id]\"><b>$a_row[title]<br></b></a>";

		//select images connected to a given listing
					$query = "SELECT * FROM tbl_Files WHERE prop_num = $a_row[id] LIMIT 1";
					$output = mysql_query("$query",$link);


					$count = 0;
					while ($image_row =mysql_fetch_array ($output) )
						{
						print "<a href=\"carview.php?view=$a_row[id]\"><img src='image.php?Id=$image_row[id_files]' border=1 width=150 alt=\"Photo\"></a><br>";
						$count++;
						}

					if ($count == 0)
						{
						print "<a href=\"./carview.php?view=$a_row[id]\"><img src=\"./images/nophoto.gif\" border=1 width=100 alt=\"View Listing\"></a><br>";
						}

					print "<font face=\"arial\">$a_row[year] $a_row[model] $a_row[type]<BR></font>";
					//print "\$$a_row[price]";

		}
		print "</td></tr></table>";

[Anon]

Assuming you want to have two rows of three columns then you should try using mod (%) to limit the number of iterations of the loop for each row.

Try something like:
$query = "SQL statement";
$result = mysql_query($query);

$i=0;
$number = mysql_num_rows ($result)

while ($i < $number)
{

$x = mysql_result(result,$i,"x_field_name");
$y = mysql_result(result,$i,"y_field_name");

if (($i % 3) == 0)
echo "<tr>";
echo "<td> html stuff and $x more html and $y"</td>;

if (($i % 3) == 2)
echo "</tr>";

$i++;

}

It may take a few trails to get the look and output you want but this will get you three cells across.

Good Luck

Jon Bertsch