hi!
Am having a problem inserting password after encrypting into a column of a table. am using MySQL.
$[PHP]loginid = $_POST['loginid'];
$password = $_POST['password'];
$encrypt_password = md5($password);
if ($_POST['submit']) {
mysql_select_db("CSU", $con);
$sql="INSERT INTO login2 (loginid, password, privilege) VALUES ('$_POST[loginid]', $encrypt_password, '$_POST[privilege]')";
if (!mysql_query($sql,$con)) {die('Error: ' . mysql_error()); }
mysql_close($con)
;}[/PHP]
table columns are loginid, password, privilege
column for insert into is password, Not Null, VarChar(40).
Getting the error Unknown column 'bc7hjsfsd8sse3sder3...' in field list.