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.
Re: MySQL select statement isn't working.
well it's only going to work if the PASSWORD function was used when inserting the records in the first place.
-tg
Re: MySQL select statement isn't working.
Resolved this one by banging a ";" at the end of the $q = line OOPS