[SOLVED] small rows display problem

[ryan king]

I accidently posted this in another thread.. this is its correct place Im sure.

 

Hello all,

 

I have a zipcode radius script that I have implemented into my website.

Everything is working fine except when you enter a zip from the form it displays the results wrong.

I want it to display 4 results per row then start a new row and loop through this to the end.

if you just hit "GO" on the form then it displays all results and it displays them correctly.

Giving it a zipcode in the form just makes the results go strait down the page.

What am I doing wrong?  the variable $key is somehow not going through my table loop correctly.

 

you can check the what I mean here.

http://idilla.com/ziptest.html

try not entering anything and hit GO to see what it is suppsoed to do and then use zipcode 36606 to see what it does on a form entry

 

here is my code:

 

<?php 

    

print "<link href='/skins/Cobalt/Cobalt.css' rel='stylesheet' type='text/css' media='screen'>";
require('include/jamroom-include.inc.php'); 
require_once('zipcode.class.php');      // zip code class 


$row_count = 0; 
$z = new zipcode_class; 
$zips = $z->get_zips_in_range($_POST['zip_code'], $_POST['miles'], _ZIPS_SORT_BY_DISTANCE_ASC, true); 
// add searched for zip to $zips array 
$zips[$_POST['zip_code']] = 0; 
$row_count = 0; 


foreach ($zips as $key => $value){


//find all locations within range using returned zipcode values 
$sql_events = mysql_query("SELECT * FROM jamroom_band_info WHERE band_zipcode='$key'") or die (mysql_error()); 


$entriesperline=4;
$counter=1;
print "<table>";


while ($row = mysql_fetch_array($sql_events)) 
{

if($counter%$entriesperline==1)
{


print "<tr><td align='center'><div class='body-zip'><a href=\"members/{$row['band_id']}\">{$row['band_name']}</a><br><a href=\"members/{$row['band_id']}\"><img border='0' src=\"image.php?band_id={$row['band_id']}&mode=band_image&width=100&theme=Sage\">{$row['band_image']}</a></div></td>";

}
else if($counter%$entriesperline==0)
  {
print "<td align='center'><div class='body-zip'><a href=\"members/{$row['band_id']}\">{$row['band_name']}</a><br><a href=\"members/{$row['band_id']}\"><img border='0' src=\"image.php?band_id={$row['band_id']}&mode=band_image&width=100&theme=Sage\">{$row['band_image']}</a></td></div></tr>";


  }
  else
  {
print "<td align='center'><div class='body-zip'><a href=\"members/{$row['band_id']}\">{$row['band_name']}</a><br><a href=\"members/{$row['band_id']}\"><img border='0' src=\"image.php?band_id={$row['band_id']}&mode=band_image&width=100&theme=Sage\">{$row['band_image']}</a></div></td>";

}
  $counter++;
} //exit loop
$counter--;
if($counter%$entriesperline!=0)
{
  print "</tr>";
}


print "</table>";



}



?>

 

any help to fix this issue would be greatly apreciated! Thanks

[fenway]

Relevant thread is here.