DarthViper3k Posted January 31, 2003 Share Posted January 31, 2003 I created my registration page and I was tryin to test it to see if it works well when I click on submit I get this... Column count doesn\'t match value count at row 1 what exactly does that mean? don\'t try to solve the problem for me if I know what that means I can probably find the problem Quote Link to comment Share on other sites More sharing options...
thejayjay Posted January 31, 2003 Share Posted January 31, 2003 sounds like you are trying to insert too many values in a row, for example you have a \"row\" that takes 3 values and you are trying to put in 4. hope that helps. Quote Link to comment Share on other sites More sharing options...
DarthViper3k Posted January 31, 2003 Author Share Posted January 31, 2003 thx man and what if thats not the case? I checked my table and checked my SQL statement and I don\'t have anymore more values in my statement than I do in the actual table Quote Link to comment Share on other sites More sharing options...
metalblend Posted January 31, 2003 Share Posted January 31, 2003 The error looks like you\'re trying something like this: INSERT INTO tbl (name,url) VALUES (\'$name\',\'$url\',\'$other_var\',\'$possible_other_var\') ..where you say you\'re going to insert into 2 columns but give more than 2 values. Hope this helps. Quote Link to comment Share on other sites More sharing options...
DarthViper3k Posted January 31, 2003 Author Share Posted January 31, 2003 The error looks like you\'re trying something like this: INSERT INTO tbl (name,url) VALUES (\'$name\',\'$url\',\'$other_var\',\'$possible_other_var\') ..where you say you\'re going to insert into 2 columns but give more than 2 values. Hope this helps. yea I know but my problem is I\'m not inserting more than what I have SQL query [php:1:c5e8d6fe77]$sql = mysql_query(\"INSERT INTO users (username, password, email, info, quote, aimsn, icq, msn, sig, signup_date) VALUES(\'$username\', \'$db_password\', \'$htminfo\', \'$quote\', \'$aimsn\', \'$icq\', \'$msn\', \'$htmsig\', now())\") or die(mysql_error());[/php:1:c5e8d6fe77]my database email username PASSWORD info quote aimsn icq msn sig user_level signup_date last_login activated lol I just noticed it Quote Link to comment Share on other sites More sharing options...
effigy Posted February 1, 2003 Share Posted February 1, 2003 add the email to the insert? :shock: Quote Link to comment Share on other sites More sharing options...
DarthViper3k Posted February 1, 2003 Author Share Posted February 1, 2003 add the email to the insert? :shock: yea I didn\'t notice it till after I posted the code already lol talk bout being blind no wonder I wear glasses LOL Quote Link to comment Share on other sites More sharing options...
metalblend Posted February 1, 2003 Share Posted February 1, 2003 Glad you/we figured it out. 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.