Column count doesn't match value count at row 1

[WalstonNet]

I am building a login system for a client based on a tutorial I purchased at DMX Zone. I desperately need help as I keep getting an error and just can't figure it out. 🙁 I am sort of new to php/mysql, just so you know.

The error I get when trying to submit the form is:

"Column count doesn't match value count at row 1"

I am attaching the file that I am having problems with as a text file (pasting the code was too long, so it wouldn't let me and it wouldn't let me attach a php file).

Can someone please help me out?

Thanks guys, I appreciate it!

[Sxooter]

$insertSQL = sprintf("INSERT INTO users (user_name, user_email, user_password, user_address, user_city, user_state, user_zip, user_phone, user_signup_date,

user_hash) VALUES (%s, %s, %s, %s)", ...

See how you're listing like ten items to insert, butyou're only putting 4 strings in there?

[WalstonNet]

Actually, I was reading a lot of the posts here for people having the exact same problem as I am and came across a post that explained the same solution , so I made sure that all 13 strings were in there, but it didn't work. I still get the same error. ??? 🙁

[Sxooter]

Ummm. There's 10 values. You need to have exactly as many %s, entries as you have in the insert field list, and a matching number of arguments to the sprintf. And, strings need to be quoted.

[WalstonNet]

Ok, I'll take out the hidden ones and see if that works. How do I quote the strings? Thanks for your help Sxooter!!!

[Sxooter]

You quote with single quotes. Your final query should look something like this:

insert into table (textfield1, textfield2, numericfield1, numericfield2) values ('abc','def',123,8949);

So, you use the single tick or quote to quote your text values.

You should be able to either stick them in the string portion of your sprintf.

[csn]

Can sprintf (automatically) escape strings (i.e. that's becomes that''s)?