1136: Column count doesn't match value count at row 1

[krislives]

Hi all,

 

I'm new to php, and im getting the above error which can only be linked to my insert statement:

 

<?php
$sql =  "INSERT INTO ".$_CONF['tprefix']."players (id, lname, fname, birthday, email, hphone, wphone, address, teamid, position, number, info, photo, registered, requested, uname, password, mphone) VALUES ('','$lname','$fname','$birthday','$email','$hphone','$wphone','$address','$teamid','$position','$number','','','0','$requested','$uname','$password','$mphone')";
?>

Table has the following columns:

 

Id, lname, fname, birthday, email, hphone, wphone, address, teamid, position, number, info, photo, registered, requested, uname, password, mphone.

 

I've researched the error message on google, and it seems to happen when you are trying to insert more columns from my "insert" statment then what is in my table.

 

I don't see that in what I have above. Can someone shed the light with the knowledge.

 

Many Thanks

[krislives]

I have now solved this problem...

 

How do I close this thread?

 

Thanks

[.josh]

did you check your actual table in phpmyadmin or w/e and make sure that all of those columns exist (and are spelled right) and there's no more?

 

edit:

 

what was the solution (and mark it as solved, bottom left)