ændringsformular opdaterer ikke ændringer
HejNedenstående ændringsformular vil ikke opdatere felterne der ændres.
Når den indlæsses finder den de rigtige værdier.
Når felterne ændres og der trykkes på afsendelsesknappen, kører den fint igennem og gives mig succes-resultatet, men den har ikke ændret noget?
Er der en der kan hjælpe?
På forhånd mange tak.
------------------------
<link rel="stylesheet" type="text/css" href="style.css"><?
if($up==ja){
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("UPDATE `bil_bil` SET `kategori` = '$kategori' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `maerke` = '$maerke' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `model` = '$model' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `variant` = '$variant' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `type` = '$type' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `bstof` = '$bstof' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `farve` = '$farve' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `aar` = '$aar' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `afgift` = '$afgift' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `special` = '$special' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `pris` = '$pris' WHERE `id` = '$id' ");
$foresp = mysql_query("UPDATE `bil_bil` SET `km` = '$km' WHERE `id` = '$id' ");
echo "<center><table cellspacing='0' cellpadding='0' width='600'><tr><td background='knapper/toppen.jpg' width='600' height='90'> </td></tr><tr><td background='knapper/linien.jpg'><center>
<br>
<br><img src='knapper/succesc.jpg'></center><br><br>
<br><br><br><center><a href='retbil.php'><img src='knapper/retur.jpg' border='0'></a>
<br>
<br></center></td></tr><tr><td background='knapper/bunden.jpg' width='600' height='5'></td></tr></table></center>";
?>
<?
}else{
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
?>
<?php
$forespa = mysql_query("SELECT kategori, maerke, model, variant, type, bstof, farve, aar, pris, km, afgift, special FROM bil_bil WHERE id = '$id' ");
while ($dataa = mysql_fetch_row($forespa)){
$vigtig = $dataa['0'];
$vigtiga = $dataa['1'];
$vigtigb = $dataa['2'];
$vigtigc = $dataa['3'];
$vigtigd = $dataa['4'];
$vigtige = $dataa['5'];
$vigtigf = $dataa['6'];
$vigtigg = $dataa['7'];
$vigtigh = $dataa['8'];
$vigtigi = $dataa['9'];
$vigtigj = $dataa['10'];
$vigtigk = $dataa['11'];
?>
<FORM METHOD=POST ACTION='rettelse3.php?up=ja'>
<table cellspacing="3" cellpadding="3" width="90%">
<tr valign="top">
<td bgcolor="#efefef">
<h2><b>Kategori:</b>
<br>
<select name="kategori">
<?php
$foresp = mysql_query("SELECT id, kategori FROM bil_kategori WHERE id <> '1' ORDER BY id DESC ");
$valgtId = $vigtig;
while ($data = mysql_fetch_row($foresp)){
if ($data[0] == $valgtId){
$strSelected = "selected";
}else{
$strSelected = "";
}
echo "<option value=$data[0] $strSelected>$data[1]</option>";
}
?>
</select>
</h2></td>
<td bgcolor="#d2d2d2"><h2><b>Bilmærke:</b>
<br>
<select name="maerke">
<?php
$foresp = mysql_query("SELECT id, maerke FROM bil_maerke WHERE id <> '1' ORDER BY id DESC ");
$valgtId = $vigtiga;
while ($data = mysql_fetch_row($foresp)){
if ($data[0] == $valgtId){
$strSelected = "selected";
}else{
$strSelected = "";
}
echo "<option value=$data[0] $strSelected>$data[1]</option>";
}
?>
</select>
</h2></td>
<td bgcolor="#efefef"><h2><b>Bilmodel:</b>
<br>
<select name="model">
<?php
$foresp = mysql_query("SELECT id, model FROM bil_model WHERE id <> '1' ORDER BY id DESC ");
$valgtId = $vigtigb;
while ($data = mysql_fetch_row($foresp)){
if ($data[0] == $valgtId){
$strSelected = "selected";
}else{
$strSelected = "";
}
echo "<option value=$data[0] $strSelected>$data[1]</option>";
}
?>
</select>
</h2></td>
<td bgcolor="#d2d2d2"><h2><b>Variant:</b>
<br>
<select name="variant">
<?php
$foresp = mysql_query("SELECT id, variant FROM bil_variant WHERE id <> '1' ORDER BY id DESC ");
$valgtId = $vigtigc;
while ($data = mysql_fetch_row($foresp)){
if ($data[0] == $valgtId){
$strSelected = "selected";
}else{
$strSelected = "";
}
echo "<option value=$data[0] $strSelected>$data[1]</option>";
}
?>
</select>
</h2></td>
</tr>
<tr valign="top">
<td bgcolor="#d2d2d2"><h2><b>Type:</b>
<br>
<select name="type">
<?php
$foresp = mysql_query("SELECT id, type FROM bil_type WHERE id <> '1' ORDER BY id DESC ");
$valgtId = $vigtigd;
while ($data = mysql_fetch_row($foresp)){
if ($data[0] == $valgtId){
$strSelected = "selected";
}else{
$strSelected = "";
}
echo "<option value=$data[0] $strSelected>$data[1]</option>";
}
?>
</select>
</h2></td>
<td bgcolor="#efefef"><h2><b>Brændstof:</b>
<br>
<select name="bstof">
<?php
$foresp = mysql_query("SELECT id, bstof FROM bil_bstof WHERE id <> '1' ORDER BY id DESC ");
$valgtId = $vigtige;
while ($data = mysql_fetch_row($foresp)){
if ($data[0] == $valgtId){
$strSelected = "selected";
}else{
$strSelected = "";
}
echo "<option value=$data[0] $strSelected>$data[1]</option>";
}
?>
</select>
</h2></td>
<td bgcolor="#d2d2d2"><h2><b>Farve:</b>
<br>
<select name="farve">
<?php
$foresp = mysql_query("SELECT id, farve FROM bil_farve WHERE id <> '1' ORDER BY id DESC ");
$valgtId = $vigtigf;
while ($data = mysql_fetch_row($foresp)){
if ($data[0] == $valgtId){
$strSelected = "selected";
}else{
$strSelected = "";
}
echo "<option value=$data[0] $strSelected>$data[1]</option>";
}
?>
</select>
</h2></td>
<td bgcolor="#efefef"><h2><b>Årgang:</b>
<br>
<select name="aar">
<?php
$foresp = mysql_query("SELECT id, aar FROM bil_aar WHERE id <> '1' ORDER BY id DESC ");
$valgtId = $vigtigg;
while ($data = mysql_fetch_row($foresp)){
if ($data[0] == $valgtId){
$strSelected = "selected";
}else{
$strSelected = "";
}
echo "<option value=$data[0] $strSelected>$data[1]</option>";
}
?>
</select>
</h2></td>
</tr>
<tr valign="top">
<td bgcolor="#efefef"><h2><b>Pris:</b>
<br><TEXTAREA NAME="pris" cols="25" rows="1"><? echo $vigtigh; ?></textarea></h2></td>
<td bgcolor="#d2d2d2"><h2><b>Km:</b>
<br><TEXTAREA NAME="km" cols="25" rows="1"><? echo $vigtigi; ?></textarea></h2><br><br></td>
<td bgcolor="#efefef"><h2><b>Afgift:</b>
<br>
<select name="afgift">
<?php
$foresp = mysql_query("SELECT id, afgift FROM bil_afgift WHERE id <> '1' ORDER BY id DESC ");
$valgtId = $vigtigj;
while ($data = mysql_fetch_row($foresp)){
if ($data[0] == $valgtId){
$strSelected = "selected";
}else{
$strSelected = "";
}
echo "<option value=$data[0] $strSelected>$data[1]</option>";
}
?>
</select>
</h2></td>
<td bgcolor="#d2d2d2"> </td>
</tr>
<tr valign="top">
<td colspan="1" bgcolor="#d2d2d2">
<h2><b>Specialhensyn:</b>
<br>
<select name="special">
<?php
$foresp = mysql_query("SELECT id, special FROM bil_special WHERE id <> '1' ORDER BY id DESC ");
$valgtId = $vigtigk;
}
while ($data = mysql_fetch_row($foresp)){
if ($data[0] == $valgtId){
$strSelected = "selected";
}else{
$strSelected = "";
}
echo "<option value=$data[0] $strSelected>$data[1]</option>";
}
?>
</select>
</h2></td>
</tr>
</table>
<br>
<INPUT TYPE=submit VALUE=SKRIV>
</FORM><p>
</center>
<?
}
?>
