outputting formatted values

BEFOR

Generally, here's what I need to do. Right now I'm just trying to determine the best approach. This is for a site registration form and I need to output potential counties that each "member" may enter in the form of a checkbox.
I have a 'Member' table a 'MemberCounty' table and a 'County' lookup table(contains zip code, county & state as they relate each per column row )

The zip code is being passed as a url variable from a prior page.
With it, I intend to be able to come up with a query (seperately) that will help output the counties within 'X' miles of the zip.

These are checkboxes that the member selects as a service territory.

Assuming I have the query to return the relevant counties within "x" miles of eaches zip code -- basically, what do I need to output this into formatted column rows on the page? (cannot manually format each state, since many companies reside near state borders)

Also, any suqqestions on what to do about irregular numbers of returned counties (the formatting of)

Beginner language, please.

leatherback

What do you mean with formatted colums?

BEFOR

I simply want to pull from the database and fill a table so the choices seem organized. That's what I meant by format, & assumed there'd have to be columns.

Roger_Ramjet

Divide the count of records returned by the number of columns to give the number in each column. If there is a remainder then add 1.

BEFOR

That's the challenge.

It's based on a zip code being passed -- users from any given zip code will have the chance to check, checkboxes of their surrounding counties that they do business in.

Many zips will return different numbers of counties.

Either that or maybe I should try to come up with a query that will return the "30 nearest counties" if thats possibile for each zip, instead of "X" number of miles. Is it?

Roger_Ramjet

Just use the recordcount of the resultset returned by the query, whichever method you choose. This is then input to your formula and the resultant is used to control your loop.

mysql num rows to get count of results

fmod to find out if there is a remainder

or do you want someone to write the code for you???

BEFOR

message deleted by BEFOR -- answer was to use county identifier to be inserted in a many to many table to identify site "member" with "counties"