Zápis několika položek najednou do DB

Potřeboval bych pomoct s kodem, mám takovýto kod s formulářem a potřebuju aby mi přidal hráče do DB pokud ale nebude vyplněne jméno hráče tak aby nepřidal do DB prázdnou hodnotu.
momentálně to přidá pouze posledního hráče (15) a to i s prázdnou hodnotou
[pre]if($addplayer == "1"){
$data6=mysql_query ("select * from tymy");
?>
<form action="addplayer.php?addplayer=2" method="post">
<select name="tym">
<? while ($data5= MySQL_Fetch_Array($data6)):
{
?>
<option value='<? echo $data5["team_id"];?>'><? echo $data5["team_name"];?></option>
<?}endwhile;?>
</select>
Jméno:<input type="text" name="pl_name1" />
Čislo:<input type="text" name="cislo1" />
Post: <select name="post1">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name2" />
Čislo:<input type="text" name="cislo2" />
Post: <select name="post2">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name3" />
Čislo:<input type="text" name="cislo3" />
Post: <select name="post3">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name4" />
Čislo:<input type="text" name="cislo4" />
Post: <select name="post4">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name5" />
Čislo:<input type="text" name="cislo5" />
Post: <select name="post5">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name6" />
Čislo:<input type="text" name="cislo6" />
Post: <select name="post6">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name7" />
Čislo:<input type="text" name="cislo7" />
Post: <select name="post7">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name8" />
Čislo:<input type="text" name="cislo8" />
Post: <select name="post8">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name9" />
Čislo:<input type="text" name="cislo9" />
Post: <select name="post9">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name10" />
Čislo:<input type="text" name="cislo10" />
Post: <select name="post10">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name11" />
Čislo:<input type="text" name="cislo11" />
Post: <select name="post11">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name12" />
Čislo:<input type="text" name="cislo12" />
Post: <select name="post12">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name13" />
Čislo:<input type="text" name="cislo13" />
Post: <select name="post13">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name14" />
Čislo:<input type="text" name="cislo14" />
Post: <select name="post14">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
Jméno:<input type="text" name="pl_name15" />
Čislo:<input type="text" name="cislo15" />
Post: <select name="post15">
<option value='1'>Útočník</option>
<option value='2'>Obránce</option>
<option value='3'>Golman</option>
</select>
<br/>
<input type="submit" value='Přidat hráče' />
</form>
<?

}

if($addplayer == "2"){
if (isset($_POST['pl_name1']) && isset($_POST['pl_name2']) && isset($_POST['pl_name3']) && isset($_POST['pl_name4']) && isset($_POST['pl_name5']) && isset($_POST['pl_name6']) && isset($_POST['pl_name7']) && isset($_POST['pl_name8']) && isset($_POST['pl_name9']) && isset($_POST['pl_name10']) && isset($_POST['pl_name11']) && isset($_POST['pl_name12']) && isset($_POST['pl_name13']) && isset($_POST['pl_name14']) && isset($_POST['pl_name15']))
{
$tym = $_POST['tym'];

$pl_name1 = $_POST['pl_name1'];
$cislo1 = $_POST['cislo1'];
$post1 = $_POST['post1'];

$pl_name2 = $_POST['pl_name2'];
$cislo2 = $_POST['cislo2'];
$post2 = $_POST['post2'];

$pl_name3 = $_POST['pl_name3'];
$cislo3 = $_POST['cislo3'];
$post3 = $_POST['post3'];

$pl_name4 = $_POST['pl_name4'];
$cislo4 = $_POST['cislo4'];
$post4 = $_POST['post4'];

$pl_name5 = $_POST['pl_name5'];
$cislo5 = $_POST['cislo5'];
$post5 = $_POST['post5'];

$pl_name6 = $_POST['pl_name6'];
$cislo6 = $_POST['cislo6'];
$post6 = $_POST['post6'];

$pl_name7 = $_POST['pl_name7'];
$cislo7 = $_POST['cislo7'];
$post7 = $_POST['post7'];

$pl_name8 = $_POST['pl_name8'];
$cislo8 = $_POST['cislo8'];
$post8 = $_POST['post8'];

$pl_name9 = $_POST['pl_name9'];
$cislo9 = $_POST['cislo9'];
$post9 = $_POST['post9'];

$pl_name10 = $_POST['pl_name10'];
$cislo10 = $_POST['cislo10'];
$post10 = $_POST['post10'];

$pl_name11 = $_POST['pl_name11'];
$cislo11 = $_POST['cislo11'];
$post11 = $_POST['post11'];

$pl_name12 = $_POST['pl_name12'];
$cislo12 = $_POST['cislo12'];
$post12 = $_POST['post12'];

$pl_name13 = $_POST['pl_name13'];
$cislo13 = $_POST['cislo13'];
$post13 = $_POST['post13'];

$pl_name14 = $_POST['pl_name14'];
$cislo14 = $_POST['cislo14'];
$post14 = $_POST['post14'];

$pl_name15 = $_POST['pl_name15'];
$cislo15 = $_POST['cislo15'];
$post15 = $_POST['post15'];


$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name1)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo1)."','".mysql_real_escape_string($post1)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name2)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo2)."','".mysql_real_escape_string($post2)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name3)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo3)."','".mysql_real_escape_string($post3)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name4)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo4)."','".mysql_real_escape_string($post4)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name5)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo5)."','".mysql_real_escape_string($post5)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name6)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo6)."','".mysql_real_escape_string($post6)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name7)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo7)."','".mysql_real_escape_string($post7)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name8)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo8)."','".mysql_real_escape_string($post8)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name9)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo9)."','".mysql_real_escape_string($post9)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name10)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo10)."','".mysql_real_escape_string($post10)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name11)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo11)."','".mysql_real_escape_string($post11)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name12)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo12)."','".mysql_real_escape_string($post12)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name13)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo13)."','".mysql_real_escape_string($post13)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name14)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo14)."','".mysql_real_escape_string($post14)."')";
$sql= "INSERT INTO hraci (pl_name, team_id, cislo, post) VALUES ('".mysql_real_escape_string($pl_name15)."','".mysql_real_escape_string($tym)."','".mysql_real_escape_string($cislo15)."','".mysql_real_escape_string($post15)."')";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "<p>hráči byl

neco jsem o tom cyklusu for přečet ale moc jsem nepochopil jak ho dosadit a jak přesně funguje, ta podminka by měla byt toto (pokud se nepletu)

spiš potřebuju vyřešit problem jak to zapsat cele na 1 zapisuje to jen to posledni $sql

už jsem to vyřešil tedkom ještě bych potřeboval poradit jak udělat aby to nezapisovalo do DB prazdnou hodnotu

vyřešil jsem to takto, ale přidá to jen 1 hráče (toho kterého zapíšu jako posledního) jak udělat aby mi to přidalo všechny?

ten 1 velky sql jsem mel a fungovalo to akorat to přidavalo i ty prázndne hodnoty ktere nechci a nevim jak tam dosadit tu podminku

co znamenaji ty hranate zavorky? jetli jsem to pochopil tak by to pak mohlo vypadat takto

akorat mi to vypsalo toto

Warning: addslashes() expects parameter 1 to be string, array given in /home/users/dawe27/testweb.hys.cz/web/4/settings.php on line 17 Warning: addslashes() expects parameter 1 to be string, array given in /home/users/dawe27/testweb.hys.cz/web/4/settings.php on line 17 Warning: addslashes() expects parameter 1 to be string, array given in /home/users/dawe27/testweb.hys.cz/web/4/settings.php on line 17 Error: Query was empty