update fra multi line updater altid den sidste hjælp
Hej kan i hjælpe mig hved jeg mangle for at kunne vælge en eller flere flere id nå den henter flere kolloner ville jeg gerne kunne ud vægle en eller flere til at update til JA i ic5 rowén<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<!-- Minus AutoDato -->
<title>Pro Consult A/S :: PROordre :: listerne</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; text-align:left;}
select{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>
<! ---------------------------------------------------- /side faver opsæting ------------------------------------------------------------------>
<! ------------------------------------------------------- List valg menu --------------------------------------------------------------------->
<center>
<table CELLPADDING="3" CELLSPACING="1" width="700">
<form method="post" action="" onsubmit="return v(this)">
<tr><td align="left" width="50"><a href="index.php"><img src="img/tilbage_pil.png" border="0"></a></td><td align="center" width="580"><h1>Pro Consult A/S - PROordre</h1></td><td></td>
</table>
<h3>Listerne</h3><p></p>
<?
$result = mysql_query("SELECT * FROM proservice WHERE ic5='NEJ'");
while($row = mysql_fetch_assoc($result)) {
echo ' <table BORDER="1" CELLPADDING="3" CELLSPACING="1" RULES="all" FRAME="BOX" height="10" width="1000"><form method="post" action="" onsubmit="return v(this)">';
echo ' <tr><input type="hidden" name="id" value="'.$row['id'].'">';
echo ' <td valign="top" width="90" bgcolor="#FF0000"> Dato:<br> '.$row['dato'].'</td>';
echo ' <td valign="top" width="150" bgcolor="#FF0000"> service report nr.:<br> '.$row['id'].' </td>';
echo ' <td valign="top" width="150" bgcolor="#FF0000"> kunde navn indsender:<br> '.$row['navn'].' </td>';
echo ' <td valign="top" width="200" bgcolor="#FF0000"> Kunde navn betaler:<br> '.$row['firma_navn'].' </td>';
echo ' <td valign="top" width="50" bgcolor="#FF0000"> revk.:<br> '.$row['revk'].' </td>';
echo ' <td valign="top" width="70" bgcolor="#FF0000"> indskavet af:<br> '.$row['v_ref'].' </td>';
echo ' <td valign="top" width="90" bgcolor="#FF0000"> lagt i C5<br><input type="checkbox" name="ic5"></td>';
echo ' </tr></table>';
echo ' <table BORDER="1" CELLPADDING="3" CELLSPACING="1" RULES="all" FRAME="BOX" height="10" width="1000">';
echo ' <tr height="20" align="center" bgcolor="#bbbbbb">';
echo ' <td valign="top">Telefon:<br>'.$row['telefon'].'</td>';
echo ' <td valign="top">Mobil:<br>'.$row['mobil'].'</td>';
echo ' <td valign="top">Adresse:<br>'.$row['adresse'].'</td>';
echo ' <td valign="top">Post nr.:<br>'.$row['by'].'</td>';
echo ' </td></tr></table>';
echo ' <table BORDER="1" CELLPADDING="3" CELLSPACING="1" RULES="all" FRAME="BOX" height="10" width="1000">';
echo ' <tr height="20" align="center" bgcolor="#bbbbbb">';
echo ' <td valign="top">Beskivsle af fejl:<br>'.$row['baaf'].'</td>';
echo ' </td></tr></table>';
echo ' <p></p>';
}
?>
<table BORDER="1" CELLPADDING="3" CELLSPACING="1" RULES="all" FRAME="BOX" height="10" width="1000">
<tr height="20" align="right" bgcolor="#bbbbbb">
<td valign="top"><input id="in" type="submit" value="Gå til Ordre liste" name="send" style="width: 220px"></td>
</td></tr></table>
</form><p></p>
<! -------------------------------------------------------/List valg menu --------------------------------------------------------------------->
<! ------------------------------------------------------- SQL funktion ----------------------------------------------------------------------->
<?
if(isset($_POST['send'])) {
if ($_POST['ic5']){
$id = $_POST['id'];
mysql_query("UPDATE `proservice` SET `ic5`='JA' WHERE id='$id'");
$result = mysql_query("SELECT * FROM proservice WHERE id='$id'");
while($row = mysql_fetch_assoc($result)) {
echo ''.$row['id'].' er nu opdatet til ic5';
}
}
}?>
<! -------------------------------------------------------/SQL funktion ----------------------------------------------------------------------->
</center>
</body>
</html>
