MySql Query Error (2)

Question

Possible Duplicate:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in select

I have this mysql query--

$mycms_query="SELECT * FROM `admin` WHERE `login`=`admin`";
$mycms_row=mysql_query($mycms_query);
echo mysql_error();
while($mycms_show=mysql_fetch_array($mycms_row)){
echo $mycms_show[passwd];
}

But when I run it it shows me this--

Unknown column 'admin' in 'where clause'

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\mycms_res\scripts\php\mycms_functions.php on line 38

Answer 1

$mycms_query="SELECT * FROM `admin` WHERE `login`='admin'";

When you use quotes like `, MySQL thinks you want a column.

So, generally speaking, you can do:

SELECT * FROM `admin` WHERE `login`='admin';
SELECT * FROM `admin` WHERE `login`="admin";

but when you do:

SELECT * FROM `admin` WHERE `login`=`admin`

you want MySQL to compare two columns in where condition -> login and admin (which you obviously don't have).

Additionally, bear in mind that when using PostgreSQL, you cannot use " operator, as it will have the same meaning as ` in MySQL.

Answer 2

You must use this

$mycms_query="SELECT * FROM `admin` WHERE `login`= 'admin'";

` is used to represent column name.