I get this error: Column count doesn't match value count at row 1

Dev Shed Forums Sponsor:

January 16th, 2013, 02:11 PM

tyler_long_sim

Registered User

Join Date: Nov 2012

Posts: 13

Time spent in forums: 3 h 23 m 4 sec
Reputation Power: 0

PHP-General - I get this error: Column count doesn't match value count at row 1

i get this error:Column count doesn't match value count at row 1

with this code:
$q = "INSERT INTO `auth` (`username`,`guid`) VALUES ('".$_GET["username"].",".$_GET["guid"]."')";

January 16th, 2013, 02:20 PM

gw1500se

Contributing User

Join Date: Jul 2003

Posts: 2,886

Time spent in forums: 1 Year 2 Weeks 3 Days 8 h 22 m 27 sec
Reputation Power: 581

What does this give you:

PHP Code:


		
			
 $q = "INSERT INTO `auth` (`username`,`guid`) VALUES ('".$_GET["username"].",".$_GET["guid"]."')";

echo $q;

I'm betting one of the $_GET values is null. Also I sure hope you are using prepared statements for that query or you are leaving yourself wide open to injections.

P.S. Note the use of [ PHP ] tags.

__________________
There are 10 kinds of people in the world. Those that understand binary and those that don't.

January 16th, 2013, 02:27 PM

tyler_long_sim

Registered User

Join Date: Nov 2012

Posts: 13

Time spent in forums: 3 h 23 m 4 sec
Reputation Power: 0

PHP Code:


		
			
 INSERT INTO `auth` (`username`,`guid`) VALUES ('tyler_long_sim,1')

~~FIX IT NOW !!!~~
FIXED IT NOW!!!

Comments on this post

Jacques1 disagrees: Who do you think you are?

Jyncka disagrees!

requinix agrees: counter

ManiacDan agrees: Adding some rep, two letters can really change a message's meaning!

Last edited by requinix : January 17th, 2013 at 02:30 AM. Reason: changing the <strike>s to [strike]s

January 16th, 2013, 02:40 PM

Jacques1

pollyanna

Join Date: Jul 2012

Location: Germany

Posts: 1,881

Time spent in forums: 1 Month 2 Weeks 2 Days 8 h 22 m
Reputation Power: 813

edit: After this, I withdraw my reply:

Quote:

Originally Posted by tyler_long_sim

FIX IT NOW !!!

Last edited by Jacques1 : January 16th, 2013 at 02:42 PM.

January 16th, 2013, 03:19 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,717

Folding Points: 417516 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 5 Months 1 Week 4 Days 7 h 29 m 55 sec
Reputation Power: 8969

Send a message via Google Talk to requinix

Quote:

Originally Posted by tyler_long_sim

PHP Code:


		
			
 INSERT INTO `auth` (`username`,`guid`) VALUES ('tyler_long_sim,1')

FIX IT NOW !!!

Dude, relax.

__________________
Site rules and FAQ | Project Suggestions | mod_rewrite guide | PHP New User Guide and FAQ - PHP Stickies | Regex Resources

January 16th, 2013, 03:34 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,717

Time spent in forums: 5 Months 1 Week 4 Days 7 h 29 m 55 sec
Reputation Power: 8969

I take it you guys haven't noticed it's his own thread and that he was yelling at himself?

January 16th, 2013, 03:43 PM

Jyncka

We're trapped inside a game!

Join Date: Jul 2008

Location: Maryland

Posts: 297

Folding Points: 37258 Folding Title: Starter Folder

Time spent in forums: 5 Days 8 h 35 m 57 sec
Reputation Power: 902

Nope, didn't realize that, in which case I apologize for my disagree, though I don't think I de-rep'd

__________________
"Those who can make you believe absurdities can make you commit atrocities."

January 16th, 2013, 03:57 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,717

Time spent in forums: 5 Months 1 Week 4 Days 7 h 29 m 55 sec
Reputation Power: 8969

Truth be told I didn't notice until after I re-repped him (and only enough to bring him out of the negatives).

Tyler, I removed the warning you got. Sorry about that but... I'm sure you can understand.

January 16th, 2013, 04:34 PM

Jacques1

pollyanna

Join Date: Jul 2012

Location: Germany

Posts: 1,881

Time spent in forums: 1 Month 2 Weeks 2 Days 8 h 22 m
Reputation Power: 813

Of course it's his own thread, but why would he yell "fix it" at himself?

If it was really just a very weird kind of, um, "self motivation", I also apologize. It sounded like rude pushing.

#10

January 16th, 2013, 04:55 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,717

Time spent in forums: 5 Months 1 Week 4 Days 7 h 29 m 55 sec
Reputation Power: 8969

Because it was a silly mistake?

#11

January 16th, 2013, 07:45 PM

sir_drinxalot

Known to taste like chicken

Join Date: Aug 2003

Location: In front of my computer

Posts: 377

Time spent in forums: 1 Week 3 h 27 m 44 sec
Reputation Power: 293

Quote:

Originally Posted by requinix

I take it you guys haven't noticed it's his own thread and that he was yelling at himself?

It is also possible he meant to say "FIXED IT NOW!!!"... just sayin...

Incase he hasn't fixed it, the issue is a couple of missing apostrophes (I am assuming this is what Jaques1 had as a solution).

PHP Code:


		
			
//his code

$q = "INSERT INTO `auth` (`username`,`guid`) VALUES ('".$_GET["username"].",".$_GET["guid"]."')";



//fixed code:

$q = "INSERT INTO `auth` (`username`,`guid`) VALUES ('".$_GET["username"]."','".$_GET["guid"]."')";

edit: Also, using $_GET directly into db queries leaves you very open to SQL injection. It would be worth looking into using prepared statements instead, or at least sanitising your input data.

__________________
"Take thy beak from out my heart, and take thy form from off my door" - Homer J Simpson / Edgar Allan Poe

Looking for a project Idea?

Last edited by sir_drinxalot : January 16th, 2013 at 07:48 PM. Reason: sql injection note

#12

January 17th, 2013, 01:41 AM

tyler_long_sim

Registered User

Join Date: Nov 2012

Posts: 13

Time spent in forums: 3 h 23 m 4 sec
Reputation Power: 0

thanks guys,

i was meant to put FIXED IT NOW!!!

sorry

Comments on this post

sir_drinxalot agrees: +20 on the right person this time!

Jyncka agrees: To make up for my previous reaction and because you got it working!

#13

January 17th, 2013, 02:31 AM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,717

Time spent in forums: 5 Months 1 Week 4 Days 7 h 29 m 55 sec
Reputation Power: 8969

Quote:

Originally Posted by tyler_long_sim

thanks guys,

i was meant to put FIXED IT NOW!!!

sorry

That makes a lot more sense

I'd consider it a personal favor if somebody repped him the +10 to get him back to where he was...

Comments on this post

sir_drinxalot agrees: +20 for good measure

#14

January 17th, 2013, 03:43 AM

sir_drinxalot

Known to taste like chicken

Join Date: Aug 2003

Location: In front of my computer

Posts: 377

Time spent in forums: 1 Week 3 h 27 m 44 sec
Reputation Power: 293

lolz, totally rep'd requinix by accident...

#15

January 17th, 2013, 09:59 AM

ManiacDan

Likely to be eaten by a grue.

Dev Shed God 10th Plane (9500 - 9999 posts)

Join Date: Oct 2006

Location: Pennsylvania, USA

Posts: 9,811

Folding Points: 127430 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 2 Months 3 Weeks 19 h 13 m 52 sec
Reputation Power: 6112

Thanks for double-checking me Requinix. Tyler's well on his way to a higher rep now. Sometimes only a couple of letters can make all the difference.

__________________
HEY! YOU! Read the New User Guide and Forum Rules

"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.

PHP-General - I get this error: Column count doesn't match value count at row 1

Developer Shed Advertisers and Affiliates