Dobrý večer, mám problém s UPDATEm, dle mého názoru mám kód správně, ale kdykoliv postnu data tak se neUPDATEují. Mohli by ste se mi na to podívat a popřípadě mi říct, kde je chyba ? 2 hodiny už se s tím trápím a už nevím kudy kam. Děkuji
<?
if($zaznam1[admin]=='0' and $zaznam1[prihlasen]=='0'){
echo "
<table width=500 height=auto valign=top align=center bgcolor=red>
<tr>
<td class=eror width=500 height=auto style=vertical-align:middle; bgcolor=white>
Vy nejste administrátor této stránky. Nemáte sem tedy přístup.
</td></tr></table>";;exit;};
?>
<br /><br /><center>
<form name="lupa" method="post" action="index.php?s=admin.php">
<table align="center" border="0"><tr><td class="admin" style="vertical-align:middle;">
<img src="o/lupa.jpg" alt="lupa" /></td>
<td style="vertical-align:middle;">
<input class="reg" type='text' name="hracnn" value="<?echo $hracnn?>" />
<input class="ok" type='submit' name="statistiky" value="Vyhledat profil" />
</td></tr></table>
</form>
</td></tr></table>
</center><br /><br />
<?php
if(isset($prava)):
if(!(isset($nadmin))){$nadmin=0;};
if(!(isset($npomocnik))){$npomocnik=0;};
if(!(isset($nministr))){$nministr=0;};
if(!(isset($nucitel))){$nucitel=0;};
if(!(isset($nostuda))){$nostuda=0;};
if(!(isset($nmoderator))){$nmoderator=0;};
if(!(isset($nprogramator))){$nprogramator=0;};
if(!(isset($nveteran))){$nveteran=0;};
MySQL_Query("UPDATE users set admin='$nadmin',pomocnik='$npomocnik',ministr='$nministr',moderator='$nmoderator',ucitel='$nhlad',ostuda='$nostuda',veteran='$nveteran',programator='$nprogramator' WHERE jmeno='$hracnn'");
endif;
if(isset($statistiky)):
$vysh = mysql_Query("SELECT * FROM users where jmeno = '$hracnn' ");
$vysh_p = mysql_num_rows($vysh);
if($vysh_p==0){
echo "
<table width=\"500\" align=\"center\" bgcolor=\"red\">
<tr>
<td class=\"eror\" width=\"500\" style=\"vertical-align:middle;\" bgcolor=\"white\">
Je mi líto, ale hledaný login neexistuje.
</td></tr>
</table><br />
";}
$hrac = mysql_Fetch_Array($vysh);
$vysh = mysql_Query("SELECT * FROM users where jmeno='$hracnn'");
$hrac = mysql_Fetch_Array($vysh);
echo "<center>";
echo "<table width=\"400\" align=\"center\" border=\"0\" bgcolor=\"black\">";
echo "<tr>";
echo "<td>";
echo "<table width=\"400\" align=\"center\" border=\"0\" bgcolor=\"white\">";
echo "<tr>";
echo "<td width=\"60\" style=\"vertical-align:middle;\">";
echo " Jméno:";
echo "</td>";
echo "<td width=\"340\" style=\"vertical-align:middle;\">";
echo "".$hrac["jmeno"]."";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td width=\"60\" style=\"vertical-align:middle;\">";
echo " Email:";
echo "</td>";
echo "<td width=\"340\" style=\"vertical-align:middle;\">";
echo "".$hrac["email"]."";
echo "</td></tr>";
echo "<tr>";
echo "<td width=\"60\" style=\"vertical-align:middle;\">";
echo " Heslo:";
echo "</td>";
echo "<td width=\"340\" style=\"vertical-align:middle;\">";
echo "".$hrac["heslo"]."";
echo "</td></tr>";
echo "<tr>";
echo "<td width=\"60\" style=\"vertical-align:middle;\">";
echo " Icq:";
echo "</td>";
echo "<td width=\"340\" style=\"vertical-align:middle;\">";
echo "".$hrac[icq]."";
echo "</td></tr>";
echo "<tr>";
echo "<td colspan=\"2\" style=\"vertical-align:middle;\">";
echo "<form name='status' method='post' action='index.php?s=admin.php'>";
echo "<center><input type='hidden' name=\"hracnn\" value=\"".$hracnn."\" />
<input type='hidden' name=\"nadmin\" />
<input type='checkbox' name=\"nadmin\" value=\"1\" ";
if($hrac[admin]=='1'){echo "checked";}
echo "/><font color=\"#00adef\">Admin</font>";
echo "<input type='hidden' name=\"hracnn\" value=\"".$hracnn."\" />
<input type='hidden' name=\"npomocnik\" />
<input type='checkbox' name=\"npomocnik\" value=\"1\" ";
if($hrac[pomocnik]=='1'){echo "checked";}
echo "/><font color=\"#aba000\">Pomocník</font>";
echo "<input type='hidden' name=\"hracnn\" value=\"".$hracnn."\" />
<input type='hidden' name=\"nministr\" />
<input type='checkbox' name=\"nministr\" value=\"1\" ";
if($hrac[ministr]=='1'){echo "checked";}
echo "/><font color=\"#3f6618\">Ministr</font>";
echo "<input type='hidden' name=\"hracnn\" value=\"".$hracnn."\" />
<input type='hidden' name=\"nucitel\" />
<input type='checkbox' name=\"nucitel\" value=\"1\" ";
if($hrac[ucitel]=='1'){echo "checked";}
echo "/><font color=\"#005825\">Učitel</font></center>";
echo "</td></tr>";
echo "<tr>";
echo "<td colspan=\"2\" style=\"vertical-align:middle;\">";
echo "<center><input type='hidden' name=\"hracnn\" value=\"".$hracnn."\" />
<input type='hidden' name=\"nmoderator\" />
<input type='checkbox' name=\"nmoderator\" value=\"1\" ";
if($hrac[moderator]=='1'){echo "checked";}
echo "/><font color=\"#662d91\">Moderátor</font>";
echo "<input type='hidden' name=\"hracnn\" value=\"".$hracnn."\" />
<input type='hidden' name=\"nostuda\" />
<input type='checkbox' name=\"nostuda\" value=\"1\" ";
if($hrac[ostuda]=='1'){echo "checked";}
echo "/><font color=\"#603913\">Ostuda</font>";
echo "<input type='hidden' name=\"hracnn\" value=\"".$hracnn."\" />
<input type='hidden' name=\"nprogramator\" />
<input type='checkbox' name=\"nprogramator\" value=\"1\" ";
if($hrac[programator]=='1'){echo "checked";}
echo "/><font color=\"#f26522\">??????</font>";
echo "<input type='hidden' name=\"hracnn\" value=\"".$hracnn."\" />
<input type='hidden' name=\"nveteran\" />
<input type='checkbox' name=\"nveteran\" value=\"1\" ";
if($hrac[veteran]=='1'){echo "checked";}
echo "/><font color=\"#f26d7d\">Veterán</font></center>";
echo "</