Password Encryption

[trinitywave]

OK i figured out the encryption part fine this is my code for that

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO tb_clients (Username, Password) VALUES (%s, password('password'))",
GetSQLValueString($HTTP_POST_VARS['Username'], "text"),
GetSQLValueString($HTTP_POST_VARS['Password'], "text"));

Now i am having a problem gettin this to work for my log in form

$FF_LoginAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING']) && $HTTP_SERVER_VARS['QUERY_STRING']!="") $FF_LoginAction .= "?".htmlentities($HTTP_SERVER_VARS['QUERY_STRING']);
if (isset($HTTP_POST_VARS['username'])) {
$FF_valUsername=$HTTP_POST_VARS['username'];
$FF_valPassword=$HTTP_POST_VARS['password'];
$FF_fldUserAuthorization="";
$FF_redirectLoginSuccess="success.php";
$FF_redirectLoginFailed="administrationtools.php";
$FF_rsUser_Source="SELECT Username, Password ";
if ($FF_fldUserAuthorization != "") $FF_rsUser_Source .= "," . $FF_fldUserAuthorization;
$FF_rsUser_Source .= " FROM tb_clients WHERE Username='" . $FF_valUsername . "' AND Password= '" . $FF_valPassword . "'";
mysql_select_db($database_nordeggrocks, $nordeggrocks);

Is there something i need to enter in this code above so php can now read the password

I can't quite make out the other thread

[laserlight]

Let's put the code aside for a while, and talk about what you are trying to do.
What exactly is your code supposed to do, step by step?

[trinitywave]

The first bit is a form that puts the username password into the database....

Then what i am building is a admin area were the user logs in and edits areas on the website... Which is the second part of the code... Two totally different pages. I cant seem to get that encrypted password to work with anything.