开发者

Unknown column 'password' in 'field list'

开发者 https://www.devze.com 2023-01-23 05:59 出处:网络
The code- $sql = \'INSERT INTO kiosk_registration ( kiosk_name, mini_info, grade, domain, phonenumber,password, referrer_id, kiosk_id, user_id)

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消