Z?v?? Posted March 22, 2007 Share Posted March 22, 2007 I seem to have a problem with creating forces on my game. It worked fine before and now it has just stopped working and is giving this error message: Column count doesn't match value count at row 1 It lets me choose the name of the force and a description of it but then when I click to create the force, it gives that error message. If anyone has any ideas I would really appreciate them. Quote Link to comment Share on other sites More sharing options...
vinyl Posted March 22, 2007 Share Posted March 22, 2007 Re: Got any Ideas? sounds like you may have added a field to 'gangs' , -but never added an 'initial' value to creategang.php for the INSERT statement.. did you try add pictures or something?? export the 'gangs' structure and copy the mysql_query("INSERT INTO gangs VALUES('','$name','$desc',''........... line from creategang.php and maybe 'we' can be of more help if you don't find it looking for the above mentioned possibility. Quote Link to comment Share on other sites More sharing options...
Z?v?? Posted March 22, 2007 Author Share Posted March 22, 2007 Re: Got any Ideas? Ya, i've added 3 new fields to my gang table in the database and now the column count doesn't match value count at row 1. Here's the exact query I have in my creategang.php: mysql_query("INSERT INTO gangs VALUES('','$name','$desc','','',0,0,100,$userid,$userid,5,0,0,'',0,0,0)",$c) or die(mysql_error()); That needs something added to it, but I'm not exactly sure where it goes. I might be wrong but I think there needs to be three more 0 fields added in there somewhere?????? Quote Link to comment Share on other sites More sharing options...
vinyl Posted March 22, 2007 Share Posted March 22, 2007 Re: Got any Ideas? just go export your 'gang' table and print of view the fields, compare them to the INSERT from creategang. put values or 2 single-quotes for each of the added fields(are all three at the end/bottom of the table???) you get the drift Quote Link to comment Share on other sites More sharing options...
Z?v?? Posted March 22, 2007 Author Share Posted March 22, 2007 Re: Got any Ideas? Nope, I don't get the drift lol Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.