all the "a" and "b" where for is a quick reference to the table. Instead of always putting tablename.columnname, you can name the table and reference it as that name

newname.columnname

Hence:

Thanks - I loaded the latest code and its starting to shape up... there are some formatting issues, but I think I can figure all of that out.

The remaining issue seems to be the table/query at the bottom of the page. It lists the Officers, their titles, email and phone. It seems to be messed up...

I didn't make any changes to your second query. I changed the first query for the results page. But the view page should be the same query as you had a long time ago, except for the "WHERE" clause.

Also, in your html, replace this:

Ok, I'll research it some more......

well, the code is identical from before...

The error message is on the following:
while ($row = mysql_fetch_array($query))

any ideas?

It is most likely telling you that you are trying to display data that isn't there.

Just for giggles, trade out the query to the one you had before, except change the WHERE clause to the current one. Maybe I made a typo somewhere.

Nope, that didn't solve it. But you have already helped me tremendously.. I'll try to figure it out. Thank you very, very much and let me know if there is anything I can do in return... I don't know maybe there is a rating thing on this forum....

There is, "Add to SheSaidImaPreggy's Reputation"

SheSaidImaPregy- are you available to answer one more question related to this thread?

Of course, just shoot.