Jump to content

unknown column


blunerve09

Recommended Posts

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?

Link to comment
https://forums.phpfreaks.com/topic/69753-unknown-column/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.