Unknown column 'city' in 'where clause'
Currently my form can query our club members db by any combination of last name, first name, or gender. We used to be able to query by city as well, but recently I broke something and, when I try to query by city, I get this message: Unknown column 'city' in 'where clause'.
1. My cities table does have a column called city. That table is the only table with a column called city, so there is no ambiguity.
2. I've scoured my PHP form process script from top to bottom several times and can find no place where the table and column are called anything but cities and city, respectively.
3. When I echo my WHERE clause, it looks like this, for example: city = 'Walnut Creek'
So another way of stating my problem is: If the db table column is called city, and the script that writes to that table refers to that column as city, and echoing the WHERE clause proves that the column name is getting picked up as city.... then what are some of the reasons that the DBMS or PHP would return a message saying: Unknown column 'city' in 'where clause' ?
Thank you all for your valuable time.