Hello everyone,
I am getting error message when trying to insert.
I get this error:
Column count doesn't match value count at row 1
I cannot figure it out. As far as I can see i have the same number of columns as values.
Here is my Insert statement:
INSERT INTO ITPlayer
(PlayerFirstName, PlayerLastName, LeagueID, PlayerDistrictID, LeagueIndexID, PlayerGoverningBodyID, PlayerBirthday, PlayerAddress, PlayerCity, PlayerProv, PlayerPostal, PlayerCountry, PlayerEmail, PlayerHomePhone, PlayerWorkPhone, PlayerWorkPHoneEx, PlayerFax, PlayerCell, PlayerNotes, PlayerDriverLicense, PlayerHealthIns, PlayerGender)
VALUES(\"$vPlayerFirstName\", \"$vPlayerLastName\", \"$leagueID\", \"$leagueDistrictID\", \"$leagueIndexID\",\"$leagueGoverningBodyID\", \"$vPlayerBirthday\",\"$vPlayerAddress\", \"$vPlayerCity\", \"$vPlayerProv\", \"$vPlayerPostal\",\"$vPlayerCountry\", \"$vPlayerEmail\",\"$vPlayerHomePhone\",\"$vPlayerWorkPhone\", \"$vPlayerWorkPhoneExt\",\"$vPlayerFax\" \"$vPlayerCellPhone\", \"$vPlayerNotes\", \"$vPlayerDriverLicense\",\"$vPlayerHealthIns\", \"$vPlayerGender\"
any ideas?
Thanks for your time. Any help is greatly appreciated.
