nicht angemeldet
hallo,
ich habe ein problem, und zwar mache ich ein UPDATE einer TABLE zeiten mitfolgendem formular.
Hat jemand ne ahnung warum das nicht geht? ich hab das schon 1000 x gemacht, finde den fehler aber nicht.
<?
include("../includes/functions.inc.php");
connectDB(1);
if($_REQUEST["action"]=="update")
{
print $query="
UPDATE zeiten SET
mo\_de='$_POST[mo_de]',
mo\_fr='$_POST[mo_fr]' ,
di\_de='$_POST[di_de]',
di\_fr='$_POST[di_fr]' ,
mi\_de='$_POST[mi_de]',
mi\_fr='$_POST[mi_fr]' ,
do\_de='$_POST[do_de]',
do\_fr='$_POST[do_fr]' ,
fr\_de='$_POST[fr_de]',
fr\_fr='$_POST[fr_fr]' ,
sa\_de='$_POST[sa_de]',
sa\_fr='$_POST[sa_fr]' ,
so\_de='$_POST[so_de]',
so\_fr='$_POST[so_fr]'
WHERE id = 1
";
mysql_query($query);
//header("Location:time.php");
}
$query2="SELECT * FROM zeiten LIMIT 0,1";
$result=mysql_query($query2);
while($data=mysql_fetch_array($result))
{
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form action="time.php?action=update" enctype="multipart/form-data" method="post" style="margin:0px; padding:0px">
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr bgcolor="#CCCCCC">
<td> </td>
<td width="24%">DE</td>
<td width="24%">FR</td>
<td width="24%">EN</td>
<td width="24%">NL</td>
</tr>
<tr>
<td bgcolor="#CCCCCC">MO</td>
<td><input type="text" name="mo_de" class="input" style="width:100%" value="<? print $data["mo_de"]; ?>" maxlength="255"></td>
<td><input type="text" name="mo_fr" class="input" style="width:100%" value="<? print $data["mo_fr"]; ?>" maxlength="255"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#CCCCCC">DI</td>
<td><input type="text" name="di_de" class="input" style="width:100%" value="<? print $data["di_de"]; ?>" maxlength="255"></td>
<td><input type="text" name="di_fr" class="input" style="width:100%" value="<? print $data["di_fr"]; ?>" maxlength="255"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#CCCCCC">MI</td>
<td><input type="text" name="mi_de" class="input" style="width:100%" value="<? print $data["mi_de"]; ?>" maxlength="255"></td>
<td><input type="text" name="mi_fr" class="input" style="width:100%" value="<? print $data["mi_fr"]; ?>" maxlength="255"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#CCCCCC">DO</td>
<td><input type="text" name="do_de" class="input" style="width:100%" value="<? print $data["do_de"]; ?>" maxlength="255"></td>
<td><input type="text" name="do_fr" class="input" style="width:100%" value="<? print $data["do_fr"]; ?>" maxlength="255"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#CCCCCC">FR</td>
<td><input type="text" name="fr_de" class="input" style="width:100%" value="<? print $data["fr_de"]; ?>" maxlength="255"></td>
<td><input type="text" name="fr_fr" class="input" style="width:100%" value="<? print $data["fr_fr"]; ?>" maxlength="255"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#CCCCCC">SA</td>
<td><input type="text" name="sa_de" class="input" style="width:100%" value="<? print $data["sa_de"]; ?>" maxlength="255"></td>
<td><input type="text" name="sa_fr" class="input" style="width:100%" value="<? print $data["sa_fr"]; ?>" maxlength="255"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#CCCCCC">SO</td>
<td><input type="text" name="so_de" class="input" style="width:100%" value="<? print $data["so_de"]; ?>" maxlength="255"></td>
<td><input type="text" name="so_fr" class="input" style="width:100%" value="<? print $data["so_fr"]; ?>" maxlength="255"></td>
<td> </td>
<td> </td>
</tr>
</table>
<br><input type="submit" class="input1" value="UPDATE">
</form>
</body>
</html>
<? } ?>