MySQL select statement isn't working.

[KiwiDexter]

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

	// 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.

[techgnome]

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

-tg

[KiwiDexter]

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