Unknown column admin in where clause

[karthikeyanck]

I'm a newbie, I've installed PHP, Apache and MySQL on my Ubuntu system

I've trouble in quering the data from MySQL when using the query function within PHP.

I 've created a Database "test", Table "employee", i 've two columns "username" and "password", I've data "admin" and "admin" on both username and the password columns. $u and $p variables has "admin".

<?php
 
$query = "SELECT username and password FROM employee WHERE username = $u AND password = $p";
 
$result = mysql_query ($query);
 
?>

When i execute the same iget this error

Unknown column admin in where clause

is the query statement correct ?


Any help appreciated !

[MarkoKlacar]

Hi,

the statement needs to be changed in the following way, your variable names should look like this '$u' and '$p' otherwise they are parsed incorrectly by MySQL.

Try this:

<?php
 
$query = "SELECT username and password FROM employee WHERE username = '$u' AND password = '$p'";
 
$result = mysql_query ($query);
 
?>

Hope this helps.

Cheers

[ronverdonk]

When you do not specify the values within quotes, MySQL assumes that they are column names in that table. Hence the error.

Ronald

[karthikeyanck]

Thanks a ton !!!!!!!
The issue is solved

[pbmods]

Changed thread title to better describe the problem.

Please use CODE tags when posting source code:

[CODE=php]
PHP code goes here.
[/CODE]