Pulling data from MySql into an array, then comparing the array's data to an existing variable?

I this code needs to be reworked. It's doing a lot of work in PHP that should be done in SQL. Do you have the ability to create new MySQL tables?

If so, I would create 2 new tables (prefixes, suffixes) and I would pull the states query into the main query so you're not doing a separate query (extra DB hit).

If there's a problem you'll have to isolate it in this code to resolve it, it's a bit messy at the moment. It looks like the recordID GETVAR is being used to lookup a user account in the database. You should verify an id is getting passed in the request and that the user account is getting loaded from the database.

Then step through an find out what else might not be working, you can clean up the code as you go. I've started out by cleaning up those spurious else if blocks.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.