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.

[Rabbit]

When you get an error code, the full error message tells you what line the error is on.

[sohomoto3]

it does not. It states what I wrote in the beginning "Can't connect because Unknown column 'Seminole' in "where clause'"

[Rabbit]

From the PHP manual:

The PHP errors which are normally returned can be quite helpful to a developer who is trying to debug a script, indicating such things as the function or file that failed, the PHP file it failed in, and the line number which the failure occurred in.

If you are not seeing it, then you are either looking in the wrong place or you have it turned off.

[Rabbit]

From the little information I have, it looks like the error is probably in your dropdown function. But you haven't posted that code so I can't be sure.

[sohomoto3]

isn't that line 18 on post 11?

[sohomoto3]

// Generating the group drop down menu
19. echo "<select onChange='reload(this.form)' name='Group'>";

[Rabbit]

Post 11, line 18 is the getGroupIndex function. Not the dropdown function.

I don't know why you copied and pasted that line of code in post #21. That has nothing to do with the dropdown function.