Password-Verification

How can I verify with PHP a Password that i saved in a MYsql-database with the function PASSWORD() ??

i have saved the password with:

$result = mysql_db_query("databse","insert into table (user,pass) values('user1',password('hello'))");

now i would like to compare the password in the databse with the entered password in a form!
can anybody help me??

First check it out wether password is existing in the database or not.After that you can insert the value into the database.


$result = mysql_query("select * from table where pass='$pass'",$con);

if mysql_num_rows($result)==0{
// Now save record here
}else{
echo "Error!! Hit Back and Change the Passwordn";

exit;

}




------------------
SR -
shiju.dreamcenter.net

"The fear of the LORD is the beginning of knowledge..."