Need a lil help with this

programming
1

I have a script that i need a little help with. I think ive got it correct but something is missing because when i go to run it it doesnt work the way it should.


<?php
    if ( isset( $_POST['post'] ) )
    {
        $names = $_POST['name'];
        $positions = $_POST['position_id'];
        $i = 1;
        
        foreach ( ($names as $name) && ($positions as $position_id) )
        {    
            $name = trim($name);
            $value[$i] = $name;

            if ( !empty($name) ) 
            {    
                mysql_query( 'INSERT INTO players (player_id, player_name, position_id, team_id) VALUES ("","'.$name.'","'.$positions.'","1")');
            }

            ++$i;
        }
    }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="Content-language" content="en-US" />
<title></title>

</head>
<body>
    <form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>" >
        <ol>
            <?php
                for ( $i = 1; $i <= 10; ++$i )
                {
            ?>
            <li>
                <label><span>Name</span> 
                    <input type="text" name="name[]" value="<?php echo $value[$i]; ?>" />    
                </label>
                <label><span>Position</span>
                            <select name="position_id[]" id="position">
              <option value="1">Manager</option>
              <option value="2" selected="selected">Pitcher</option>
              <option value="3">Catcher</option>
              <option value="4">1st Base</option>
              <option value="5">2nd Base</option>
              <option value="6">Short Stop</option>
              <option value="7">3rd Base</option>
              <option value="8">left Field</option>
              <option value="9">Center Field</option>
              <option value="10">Right Field</option>
              <option value="11">DH</option>
                        </select>

                </label>

            <?php
                }
            ?>
        </ol>
        <input type="submit" name="post" value="Submit" />
    </form>
</body>
</html>

what it is not doingis adding the position number in the insert query infarct it is ignoring it all together…

any ideas what im doing worng?