phpmysqlphpmyadminmysqladmin

Unknown column 'userpass' in 'field list'

I'm working on the following project: http://lpmj.net/20.php

I've made several entries into phpMyadmin and am getting used to making the mySQL and php correspond, but with this error i have no idea what the code is asking for.

This is the error i'm recieving:

Unknown column 'userpass' in 'field list'

Any help what this is indicating would be appreciated.

Solution

  • This means that your field-list — the stuff right after the word SELECT — refers to a column named userpass, but that that column doesn't exist in the table(s) you're selecting from. For example, maybe your query looks like this:

    SELECT userpass FROM foo;

    when it should actually look like one of these:

    SELECT userpass FROM bar;  -- was looking in the wrong table
SELECT user_pass FROM foo; -- mistyped the name of the column