INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

    if ($i > 0  ) {
	$player_num = "player";
    $player_num .= $i;
             $player = trim(mysql_prep($_POST));
            $league_id = trim(mysql_prep($leauge_records));
             $query = "INSERT INTO players(
                player_id , league_id , 
                )VALUES(
                {$player},{$league_id}
                )";
                $result = mysql_query($query,$connection);
                if ($result) {
                    //Success
                    $message = "המשתמש נוצר בהצלחה.";
               echo $message;
                }
                else {
                     //Failed
                    $message = "לא נכנס לרשומות בכלל.";
                }
                
             
             } else {
               //error occurred
               $message  = "התגלתה שגיאה בהרשמה, בדוק שוב את השדות";
            
			}
             echo $_POST ;
			 
			  echo "</br>".$message."</br>";
			}