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.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.3 32 bit - Apache 2.4.35 - PHP 7.2.10/7.1.22/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.9
Wampserver 3.1.3 64 bit - Apache 2.4.35 - PHP 7.2.10/7.1.22/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.9
PhPMyadmin 4.8.3 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.