Can't connect because Unknown column 'XXX' in "where clause'

[sohomoto3]

I removed a group name and the database looks fine. All works fine except for 1 group and if you select it then you get the error "Can't connect because Unknown column 'XXX' in "where clause'" The column it is talking about is the one which was removed and doesn't exist. The # of groups total 8 yet the php request is looking for group 9
?GroupID=9

[Rabbit]

Then remove that group from the code.

That's all we can say since you didn't post the code.

[sohomoto3]

Nothing I enter is helping the expert to help me

[sohomoto3]

Nothing I enter is helping the expert to help me

[Rabbit]

I thought you said you removed group 9 from everywhere? I see it right there in your dropdown.

[sohomoto3]

Group 9 "Work Care" is correct
Seminole Group is what I removed?

[Rabbit]

It can't possibly be correct to have a group 9. You said in your very first post that you only have 8 groups and that you removed group 9. It doesn't matter what you call your group 9 in your drop down, you have no group 9. It doesn't matter that your group 9 in your drop down doesn't match the group 9 in your database.

[sohomoto3]

It shows in the code that Group 1 is "Choose" which essentially does nothing. Then it follows through with the 8 groups. I understand your point but when I run the search for all the other groups they pull up the correct data

[sohomoto3]

How is it referencing a Group called Seminole which does not exist any more?

[Rabbit]

Like I said, it doesn't matter what your intent is in your drop down. You are still trying to access a group 9 which does not exist.

Most likely because it's coded for somewhere in your PHP code. But you haven't posted your PHP code so that's all I can say.

[sohomoto3]

Nothing I enter is helping the expert to help me

[sohomoto3]

Nothing I enter is helping the expert to help me

[sohomoto3]

there is a lot of code and I am trying to pick what could be relevant

[Rabbit]

And on which line of code do you get that error?

[sohomoto3]

I apologise but I do not know that is why I am here. I pasted the first source code from the webpage which showed the error and the source behind it. I then pasted more code from the php file, but I am asking for help finding the error.