MySQL select statement isn't working.

Anyone know what the heck I'm doing wrong here?

Code:

---

        // Create Query
        $q = "SELECT * FROM rev_login WHERE username = '".$user."' and password = PASSWORD('".$password."') LIMIT 1"

        // Run Query
        $r = mysql_query($q);

---

Never used the MySQL Password thingy so may be doing something wrong there.

well it's only going to work if the PASSWORD function was used when inserting the records in the first place.

-tg

Resolved this one by banging a ";" at the end of the $q = line OOPS