带有MySQL查询的PHP if语句

Question

Is there a way to do an if statement like this:

if ($password == mysql_query("SELECT password from member WHERE id = $id")) {

// f00

}

So what I mean is, if it is possible and/or good practice to have a short query in your if, instead of extracting it from your DB first.

Thanks!

Answer 1

mysql_query returns a resource so it wont work