Unknown column exists
Posted by: rpjd (37.228.242.---)
Date: September 15, 2017 06:55PM

I'm running a query on two tables. Email is a primary key on one table. I'm selecting Email based on two other matching columns. Unknown column in where clause on one of the matching columns. Both are varchar(50). Why would server say an existing column is unknown?

Options: ReplyQuote
Re: Unknown column exists
Posted by: rpjd (37.228.242.---)
Date: September 15, 2017 07:02PM

Figured it out, left out second table before where.

Options: ReplyQuote
Re: Unknown column exists
Posted by: Otomatic (Moderator)
Date: September 15, 2017 10:11PM

Hi,

I may have misunderstood, but it would seem that you found the error in your query.

However, you are here asking a question about an error in a SQL query, but you are not saying exactly what the query is, nor is it the exact error.
Apart from the fact that this forum is not intended to debug PHP scripts or SQL queries from Wampserver users, if you do not give any relevant details, you can not guess.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote


Sorry, only registered users may post in this forum.