hjælp til at rette/update data i database(MySQL) fra PHP
Jeg har et problem jeg kan ikke få min update kode til at virke.kan i hjælpe mig.
få enten en tom side ellers vil siden ikke vise.
kan i hjælp mig i hvad jeg laver forkert.
_________________________________________________________________
<html>
<head>
<title></title>
<style>
body{scrollbar-base-color:#55AAD0; scrollbar-arrow-color:#FFFFFF;}
a{text-decoration:none; font-weight:bold;}
a:hover{color:#000000;}
td{font-family:verdana; font-size:10;}
#td{background-color:CCCCCC;}
#td2{background-color:CCCCCC;}
input{background-color:#CCCCCC; border-width:1; border-style:solid; border-color:#000000; color:#000000; font-size:10; font-family:verdana;}
</style>
</head>
<?
session_start();
include("config.php");
?>
<! ------ side faver opsæting ---------------------->
<body link=blue vlink=purple>
<center><center><img src="img/logov1.jpg" border="0" width="964" height="150" align="bottom" alt=""><br>
<h1>Algreen Multiservice I/S Ordersystem</h1></center><p align="left">
<?
$result = mysql_query("SELECT * FROM Algreenorder WHERE id='$_GET[id]'");
while($row = mysql_fetch_array($result)) { ?>
<h2>Opret ny hesteorder</h2>
<table cellspacing="0" cellpadding="0" height="800">
<tr>
<td valign="top"><form method="post" action="" onsubmit="return v(this)">
<input type="hidden" name="subject" value="">
<table>
<tr>
<td>
Afhenting dato og adresse
</td>
<td></td>
<td>Aflastings dato og adresse</td>
<td></td>
</tr>
<tr>
<tr>
<td>
Dato:</font>
</td>
<td><input id="in" type="text" name="Afhenting_dato" value="<? echo
$row[Afhenting_dato]; ?>" size="48"></td>
<td><font color="#FF0000">*</font>Dato:</td>
<td><input id="in" type="text" name="Aflaesting_dato" value="<? echo
$row[Aflaesting_dato]; ?>" size="48"></td>
</tr>
<tr>
<td>
Skal være ved kunden kl.</font>
</td>
<td><input id="in" type="text" name="Afhenting_svvkk" value="<? echo
$row[Afhenting_svvkk]; ?>" size="48"></td>
<td><font color="#FF0000">*</font>Skal være ved kunden kl.</td>
<td><input id="in" type="text" name="ss_svvkk" value="<? echo
$row[ss_svvkk]; ?>" size="48"></td>
</tr>
<tr>
<td>
Adresse:</font>
</td>
<td><input id="in" type="text" name="Afhenting_adresse" value="<? echo
$row[Afhenting_adresse]; ?>" size="48"></td>
<td>Adresse:</td>
<td><input id="in" type="text" name="Aflaesting_adresse" value="<? echo
$row[Aflaesting_adresse]; ?>" size="48"></td>
</tr>
<tr>
<td>
Post nr + by:</font>
</td>
<td><input id="in" type="text" name="Afhenting_post" value="<? echo
$row[Afhenting_post]; ?>" size="48"></td>
<td>Post nr + by:</td>
<td><input id="in" type="text" name="Aflaesting_post" value="<? echo
$row[Aflaesting_post]; ?>" size="48"></td>
</tr>
<tr>
<td>
Evt. stednavn:</font>
</td>
<td><input id="in" type="text" name="Afhenting_stednavn" value="<? echo
$row[Afhenting_stednavn]; ?>" size="48"></td>
<td>Evt. stednavn:</td>
<td><input id="in" type="text" name="Aflaesting_stednavn" value="<? echo
$row[Aflaesting_stednavn]; ?>" size="48"></td>
</tr>
<tr>
<td><br></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>
Kunde infomationer</font>
</td>
<td></td>
<td><font color="#FF0000">***</font>kontagt infomationer</td>
<td></td>
</tr>
<tr>
<td>
Navn:</font>
</td>
<td><input id="in" type="text" name="Aflaesting_kontagt" value="<? echo
$row[Aflaesting_kontagt]; ?>" size="48"></td>
<td>Navn:</td>
<td><input id="in" type="text" name="Afhenting_kontagtperson" value="<? echo
$row[Afhenting_kontagtperson]; ?>" size="48"></td>
</tr>
<tr>
<td>
Telefon:</font>
</td>
<td><input id="in" type="text" name="Aflaesting_tele" value="<? echo
$row[Aflaesting_tele]; ?>" size="48"></td>
<td>Telefon:</td>
<td><input id="in" type="text" name="Afhenting_tele" value="<? echo
$row[Afhenting_tele]; ?>" size="48"></td>
</tr>
<tr>
<td>
mobil:</font>
</td>
<td><input id="in" type="text" name="Aflaesting_mobil" value="<? echo
$row[Aflaesting_mobil]; ?>" size="48"></td>
<td>mobil:</td>
<td><input id="in" type="text" name="Afhenting_mobil" value="<? echo
$row[Afhenting_mobil]; ?>" size="48"></td>
</tr>
<tr>
<td><br></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>
Ekster infomationer</font>
</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>
Hestes/hestenes navn:</font>
</td>
<td><input id="in" type="text" name="Afhenting_hestnavn" value="<? echo
$row[Afhenting_hestnavn]; ?>" size="48"></td>
<td>Passerager:</td>
<td><input id="in" type="text" name="pas" value="<? echo
$row[pas]; ?>" size="48"></td>
</tr>
<tr>
<td><font color="#FF0000">**</font>Aftalt Pris:
</font>
</td>
<td><input id="in" type="text" name="Aftalt_Pris" value="<? echo
$row[Aftalt_Pris]; ?>" size="48"></td>
<td>Kørsle tybe:</td>
<td><input id="in" type="text" name="tt" value="<? echo
$row[tt]; ?>" size="48"></td>
</tr>
<tr>
<td>
Bemærkinger fra kontoret ang turen:</font>
</td>
<td><textarea wrap="physical" rows="5" cols="30" name="Bemaerking" id="in"><? echo
$row[Bemaerking]; ?></textarea></textarea></td>
<td>Bemærk de <font color="#FF0000">*</font></td>
<td><font color="#FF0000">*</font> Hvis Retur dagen er en anden dag end afhentingens dato<p>
<font color="#FF0000">**</font> efter lad blank hvis der ikke aftalt en fast pris<p>
<font color="#FF0000">***</font> Bruges hvis kunden ikke er på afhentings stedet<p></td>
</tr>
</table>
<?
}
?>
<p><input id="in" type="submit" value="ret" name="ret"><input id="in" type="reset" value="Nulstil" name="B2"></p>
</form><p><?
if(isset($_POST['ret'])) {
$Afhenting_dato = $_POST['Afhenting_dato'];
$Afhenting_svvkk = $_POST['Afhenting_svvkk'];
$Afhenting_adresse = $_POST['Afhenting_adresse'];
$Afhenting_post = $_POST['Afhenting_post'];
$Afhenting_stednavn = $_POST['Afhenting_stednavn'];
$Afhenting_kontagtperson = $_POST['Afhenting_kontagtperson'];
$Afhenting_tele = $_POST['Afhenting_tele'];
$Afhenting_mobil = $_POST['Afhenting_mobil']; ;
$pas = $_POST['pas'];
$Afhenting_hestnavn = $_POST['Afhenting_hestnavn'];
$Aflaesting_dato = $_POST['Aflaesting_dato'];
$ss_svvkk = $_POST['ss_svvkk'];
$Aflaesting_adresse = $_POST['Aflaesting_adresse'];
$Aflaesting_post = $_POST['Aflaesting_post'];
$Aflaesting_stednavn = $_POST['Aflaesting_stednavn'];
$Aflaesting_kontagt = $_POST['Aflaesting_kontagt'];
$Aflaesting_tele = $_POST['Aflaesting_tele'];
$Aflaesting_mobil = $_POST['Aflaesting_mobil'];
$tt = $_POST['tt'];
$Aftalt_Pris = $_POST['Aftalt_Pris'];
$Bemaerking = $_POST['Bemaerking'];
mysql_query("UPDATE Algreenorder SET Afhenting_dato = $Afhenting_dato WHERE id='$_GET[id]'");
?>
</p></td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" height="800">
<tr>
<td valign="top"></td>
</tr>
</table>
</table>
</body>
</html>
