Specialty Nursery Association of Western Washington
 Specialties & Services  Maps  All Nurseries  Sales / Events   Specialty Nursery Guide  
1 ) echo ""; else echo "
Nurseries with " . $type . "  
"; echo "
 Full Service Nurseries  
"; $i = 0; while( $i < $total) { $num = mysql_result($result,$i,"num"); $name = mysql_result($result,$i,"name"); $city = mysql_result($result,$i,"city"); echo " "; if($i + 1 == ceil($total/2)) echo "
" . $num . "  " . $name ." (". $city . ")
 "; $i++; } echo "

"; } echo "
"; //list types for indexing echo "
"; $query = "SELECT * FROM types"; $result = mysql_query($query); $total = mysql_numrows($result); $i = 0; while ($i < $total) { $type = mysql_result($result,$i,"type"); $num = mysql_result($result,$i,"num"); if($i == ceil($total/3) or $i== ceil($total * 2/3) ) echo "
 "; echo ''; $i++; } echo "
  '. $type .'
"; mysql_close(); include("footer.inc"); ?>