Unknown column 'password' in 'field list'

The code-

$sql = 'INSERT INTO kiosk_registration ( kiosk_name, mini_info, grade, domain, phonenumber, password, referrer_id, kiosk_id, user_id)

VALUES ("'.$_POST["name"].'", "'.$_POST["mini_info"].'", "'.$_POST["grade"].'", "'.$_POST["domain"].'", "'.$_POST["phone_number"].'", "'.$_POST["password"].'", "'.$_POST["ref_id"].'", "'.$kiosk_i开发者_开发技巧d.'", "'.$_SESSION['uid'].'")';

if (!mysql_query($sql,$con))

{

die('Error: ' . mysql_error());

}

The error - Unknown column 'password' in 'field list'. And this started happening on its own. It used to work perfectly fine, but this error just started appearing suddenly. I have no clue as to what could be wrong.

*Sorry guys, it was a small problem, i mixed up the files, I was updating and not inserting hence the error *

Well, this indicates that the kiosk_registration table has changed, and that the 'password' field no longer exists. Check the definition of the table in the database. Also: are you sure you're connecting to the database you think you're connecting to?

It can means only one. Your table hasn't field password. Check the table to existing this field.