[Resolved] password out of order

[prinzcy]

i use these

$result = mysql_query("select * from user where user_id='$user_id' && password=PASSWORD('$pass') && level='$level'",$link) or die(mysql_error());

to login. no error but no data found even though data does exist. can anybody help me out. it seems that the system read until that line and whooop...error, no data found....

[kbrij]

I think SQL query likes only clauses AND, OR, etc.

[prinzcy]

thanks for the reply

but...i'd tried that as well. right now i already change the code to

$result = mysql_query("select * from user WHERE user_id = 'user_id' AND password = PASSWORD('$pass') AND level = '$level'",$link);

still the same...

[prinzcy]

found the error, solved it.

how can i miss such a little details!!!!! i can't believe i stared at the same line all night but i just couldn't see where the error is. geez~