Unknown column 'password' in 'field list' HUH??!?!

[sodascape]

Anybody know what that means?

Unknown column 'password' in 'field list'

[tomfmason]

That means that you don't have a field in the db called password.. Look in phpmyadmin or whatever and make sure that the table has a field named password.

Good Luck,
Tom

[sodascape]

double checked, everything matches, there is a password field in the database and on the INSERT query ... they match, what else could it be?

[JasonLewis]

are you inserting it into the right database. is everything spelt correctly. post your code here so we can have a look.

[sodascape]

I've checked, everything is the same:
[code] $doquery = "INSERT INTO customers (id, username, password, newuser, email, fullname, birthday, city, state, zip, country)
VALUES ('0', '$username', '$password', '0', '$email', '$fullname', '$birthday', '$city', '$state', '$zip', '$country')";
$doit = mysql_query($doquery); [/code]

[JasonLewis]

so in your table customers you have all those fields. and is the field 'id' the primary key? also, is it set to auto_increment. if it isn't...i suggest you do, then you dont have to worry about it in your insert statements.
so your absolutley sure that your table customers has the field 'password'?

[sodascape]

Thank you, I'm an idiot and had the wrong table.....  I got it working........HOWEVER, I am still having a problemw with another posting I made, it's called ARRAYS and SESSIONS.... if you could check that one out, it'd be greatly appreciated.