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 Link to comment https://forums.phpfreaks.com/topic/110-column-count-doesnt-match/ 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. Link to comment https://forums.phpfreaks.com/topic/110-column-count-doesnt-match/#findComment-325 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 Link to comment https://forums.phpfreaks.com/topic/110-column-count-doesnt-match/#findComment-327 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. Link to comment https://forums.phpfreaks.com/topic/110-column-count-doesnt-match/#findComment-330 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 Link to comment https://forums.phpfreaks.com/topic/110-column-count-doesnt-match/#findComment-344 Share on other sites More sharing options...
effigy Posted February 1, 2003 Share Posted February 1, 2003 add the email to the insert? :shock: Link to comment https://forums.phpfreaks.com/topic/110-column-count-doesnt-match/#findComment-346 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 Link to comment https://forums.phpfreaks.com/topic/110-column-count-doesnt-match/#findComment-347 Share on other sites More sharing options...
metalblend Posted February 1, 2003 Share Posted February 1, 2003 Glad you/we figured it out. Link to comment https://forums.phpfreaks.com/topic/110-column-count-doesnt-match/#findComment-349 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.