unknown column

[blunerve09]

I am having problems running a query to select a username and password out of a database to log the user in. It keeps coming up with the error "unknown column 'user' in 'where clause'. I've tried to wrap the variables in quotes, but it's still not working. If i use the same query on the command line, it works, just not through the web. Here's the code:

 

$sqluser = addslashes($user);

$sqlpass = addslashes($pass);

$query = "SELECT username FROM dig_data WHERE username='$sqluser' AND password=PASSWORD('$sqlpass')";

$authuser = dbquery($query);

 

Any ideas?

[sasa]

check your typo in line $query = ...

db reports that you ask for column 'user' bat in your query i see 'username'

[blunerve09]

ok, I changed the structure of the database, and changed the query, but it's still showing the same error.