Need Help Echoing

[golfinggod]

Hi Can anyone help I am looking to echo these result onto my page in a certain order. Ideally i would like 2 rows of three banners but I am not sure how to go about this.

I can echo down the page with no problem, I am just not sure how to echo accross it.

<?php  

	  $Size = 15038;

	  $Selectid = "SELECT * FROM banners WHERE Bannersize = '$Size' order by rand() limit 6"; 

      $Result = mysql_query($Selectid); 

	  if (mysql_num_rows($Result) >0) 

	  {

	  while ($users_row = mysql_fetch_array($Result)) { 

	  $Bannerurl = $users_row['Bannerurl'] ; 

	  $Imageurl = $users_row['Imageurl'] ;

	  $Bannername = $users_row['Bannername'] ;

	  $Bannersize = $users_row['Bannersize'] ;

	  $Username = $users_row['Username'] ;

	  $Selectid2 = "SELECT Webaddress FROM website WHERE Username = '$Username' "; 

      $Result2 = mysql_query($Selectid2); 

	  $users_row2 = mysql_fetch_array($Result2);

	  $Webaddress = $users_row2['Webaddress'] ;

echo "Need To Echo Accross The Page -- ------- 2 rows of three banners";


  }}

  ?>

Any Ideas Anyone

Thanks

[devinemke]

here's one way (not tested). this is a bit more optimzed that your orginal since it does fewer hits to the database:

$size = 15038;
$sql = "SELECT * FROM banners WHERE Bannersize = '$size' order by rand() limit 6";
$result = mysql_query ($sql);

if (mysql_num_rows ($result))
{           

	while ($row = mysql_fetch_assoc ($result))
	{
		$banner_array[$row['Username']] = $row;
	}
}

$result = mysql_query ('SELECT Username, Webaddress FROM website WHERE Username IN(' . implode (',', array_keys ($banner_array)) . ')');
while ($row = mysql_fetch_assoc ($result))
{
	$banner_array[$row['Username']]['Webaddress'] = $row['Webaddress'];
}

sort ($banner_array);

$top_row = array_slice ($banner_array, 0, 3);
$bottom_row = array_slice ($banner_array, 3, 3);

echo '<table border=1><tr>';
foreach ($top_row as $key => $value)
{
	echo '<td>' . $value['Bannername'] . '</td>';
}
echo '</tr><tr>';
foreach ($bottom_row as $key => $value)
{
	echo '<td>' . $value['Bannername'] . '</td>';
}
echo '</tr></table>';

[golfinggod]

Thanks for the help