Jump to content

Archived

This topic is now archived and is closed to further replies.

DarthViper3k

Column count doesn't match....???

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.