Column count doesn't match value count at row 1

[chris_s_22]

im getting the error

Column count doesn't match value count at row 1

any advice?

 

<?php
function create_game($playername, $sex) {
        if($_POST) { 
                foreach($_POST['player'] as $post_key) { 
                $query_string .= " ('".$post_key[sex]."', '".$post_key[playername]."'),";
                } 
                $query_string = substr_replace($query_string,"",-1);
        
                // store the information in the database
                $query = "INSERT INTO `game` (`playername`, `sex`) values ('.$query_string')";
                $result = mysql_query($query) or die(mysql_error());

                // if suceesfully inserted data into database, send confirmation link to email 
                if($result) {
                        header('Location: http://www.pinkangel4u.com/truthdare/Game/gameboard.php');
                }
        }}
?>

[.josh]

Don't really know what you're going on about the title, but I fixed some errors in your code.

 

<?php
function create_game($playername, $sex) {
        if($_POST) { 
                foreach($_POST['player'] as $post_key) { 
                $query_string .= " ('".$post_key['sex']."', '".$post_key['playername']."'),";
                } 
                $query_string = substr_replace($query_string,"",-1);
        
                // store the information in the database
                $query = "INSERT INTO `game` (`playername`, `sex`) values $query_string";
                $result = mysql_query($query) or die(mysql_error());

                // if suceesfully inserted data into database, send confirmation link to email 
                if($result) {
                        header('Location: http://www.pinkangel4u.com/truthdare/Game/gameboard.php');
                }
        }}
?>

[chris_s_22]

im now getting the error

 

Warning: Invalid argument supplied for foreach() in /mounted-storage/home74b/sub009/sc42562-IQUU/www/truthdare/Game/functions.php on line 4

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1