Unknown column 'name' in 'field list'


#1

i am getting this Unknown column ‘name’ in ‘field list’ error whenever i try to execute the given code…I contacted the server admin and they said server is just fine…can u please bring out the fault as i guess it might be a coding error. The column name exists in the database…
The main codings are:

$sql = mysql_query(“INSERT INTO myMembers (name, dob, occu, college, semester, depart, rollno, email , password,sign_up_date)
VALUES(’$name’,’$dob’,’$occu’,’$college’,’$semester’,’$depart’,’$rollno’,’$email’,’$db_password’,now())”)
or die (mysql_error());


#2

If the error says the column doesn’t exist, I can’t imagine any other possible explanation than the column not existing. Are you sure you’re looking at the right table?


#3

Yes i checked many times…its in the ryt table…should i redo evth again from begnin?