sodascape Posted November 16, 2006 Share Posted November 16, 2006 Anybody know what that means?Unknown column 'password' in 'field list' Quote Link to comment Share on other sites More sharing options...
tomfmason Posted November 16, 2006 Share Posted November 16, 2006 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 Quote Link to comment Share on other sites More sharing options...
sodascape Posted November 16, 2006 Author Share Posted November 16, 2006 double checked, everything matches, there is a password field in the database and on the INSERT query ... they match, what else could it be? Quote Link to comment Share on other sites More sharing options...
JasonLewis Posted November 16, 2006 Share Posted November 16, 2006 are you inserting it into the right database. is everything spelt correctly. post your code here so we can have a look. Quote Link to comment Share on other sites More sharing options...
sodascape Posted November 16, 2006 Author Share Posted November 16, 2006 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] Quote Link to comment Share on other sites More sharing options...
JasonLewis Posted November 16, 2006 Share Posted November 16, 2006 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'? Quote Link to comment Share on other sites More sharing options...
sodascape Posted November 16, 2006 Author Share Posted November 16, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.