Opdatere mange værdier.
Jeg har lidt kode, det er sån lidt indviklet .. Men den nemmeste måde jeg kunne finde på at lave det .. :)Vil gerne ha at den skal opdatere de rækker hvor man har ændret nogen værdier .. Altså den skal opdatere alt sammen, med de værdier som man har indtastet, oss selvom man ikk har indtastet nogen skal den bare opdatere de rigtige rækker med de rigtige værdier, i kan vel selv gennemskue koden.. :)
<style>
a {
font-size : 10pt;
font-family : Arial, sans-serif;
color : #004080;
}
a:hover {
font-size : 10pt;
font-family : Arial, sans-serif;
color : #FFFFFF;
}
table {
font-family: Arial, sans-serif;
font-size: 10pt;
color: #000000;
}
tr.RowOverOdd {
background-color : #FFFFFF;
}
tr.RowOverEven {
background-color : #EFEFEF;
}
tr.RowOverSelected {
color : #FFFFFF;
background-color : #999999;
}
</style>
<body bgcolor="#EFEFEF">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="861" height="30" id="AutoNumber1">
<td width="71" height="23" align="center">
<p align="left" >
M-NR</td>
<td width="29" height="23" align="center">
<p align="left" >Pige</td>
<td width="43" height="23" align="center">
<p align="left" >Klinik</td>
<td width="74" height="23" align="center">
<p align="left" >
Navn</td>
<td width="139" height="23" align="center">
<p align="left" >
Hjemmeside</td>
<td width="125" height="23" align="center">
<p align="left" >
Adresse</td>
<td width="78" height="23" align="center">
<p align="left" >
Post-Nr</td>
<td width="124" height="23" align="center">
<p align="left" >
ByNavn</td>
<td width="74" height="23" align="center">
<p align="left" >
Tlf-Nr</td>
<td width="28" height="23" align="center">
<p align="left" >DK </td>
<td width="20" height="23" align="center">
<p align="left" >T</td>
<td width="28" height="23" align="center">
<p align="left" >
U</td>
<td width="19" height="23" align="center">
<p align="left" >E</td>
<td width="32" height="23" align="center">
<p align="left" >S/M</td>
<td width="35" height="23" align="center">
<p align="left" >
OK</td>
<td width="0" height="23" align="center">
<p align="left" >
SLET</td>
</tr>
</table>
<?
mysql_connect("localhost", "root", "");
mysql_select_db("chatnet") or die('Kunne ikke vælge database');
$query=mysql_query("SELECT * FROM users");
while($show=mysql_fetch_array($query)){
echo "<form action=\"$PHP_SELF?change=ja\" method=\"POST\">
<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"820\" height=\"30\" id=\"AutoNumber1\">
<tr onmouseover=\"this.className='RowOverSelected';\" onmouseout=\"this.className='RowOverEven';\">
<td width=\"59\" height=\"23\" align=\"center\">
<p >
<input type=\"text\" size=\"7\" NAME=\"mnummer\" value=\"$show[id]\"></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p ><input type=\"checkbox\" NAME=\"pige\" value=\"ON\""; if($show[pige]==ja){ echo "checked"; } echo "></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p ><input type=\"checkbox\" NAME=\"klinik\" value=\"ON\""; if($show[klinik]==ja){ echo "checked"; } echo "></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p >
<input type=\"text\" size=\"6\" NAME=\"navn\" value=\"$show[navn]\" ></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p >
<input type=\"text\" size=\"15\" NAME=\"webadr\" value=\"$show[website]\" ></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p >
<input type=\"text\" size=\"15\" NAME=\"adr\" value=\"$show[adresse]\"></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p >
<input type=\"text\" size=\"4\" NAME=\"post\" value=\"$show[pnr]\"></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p >
<input type=\"text\" size=\"15\" NAME=\"bynavn\" value=\"$show[bn]\"</td>
<td width=\"59\" height=\"23\" align=\"center\">
<p >
<input type=\"text\" size=\"8\" NAME=\"tlf\" value=\"$show[tlr]\"></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p ><input type=\"checkbox\" NAME=\"dansk\" value=\"ON\""; if($show[dk]==ja){ echo "checked"; } echo "></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p ><input type=\"checkbox\" NAME=\"thai\" value=\"ON\""; if($show[thai]==ja){ echo "checked"; } echo "></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p >
<input type=\"checkbox\" NAME=\"udenl\" value=\"ON\""; if($show[ul]==ja){ echo "checked"; } echo "></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p ><input type=\"checkbox\" NAME=\"escort\" value=\"ON\""; if($show[escort]==ja){ echo "checked"; } echo "></td>
<td width=\"59\" height=\"23\" align=\"center\">
<p ><input type=\"checkbox\" NAME=\"sm\" value=\"ON\""; if($show[sm]==ja){ echo "checked"; } echo "></td>
<td width=\"60\" height=\"23\" align=\"center\">
<p >
<input type=\"checkbox\" NAME=\"godkendt\" value=\"True\""; if($show[godkendt]==ja){ echo "checked"; } echo "></td>
<td width=\"60\" height=\"23\" align=\"center\">
<p >
<input type=\"checkbox\" NAME=\"slet\" value=\"$show[id]\"></td>
</tr>
</table>
</div>
";
}echo "
<input type=\"submit\" name=\"change\" value=\"Opdater\">
</form> "; ?>
Hvorn gøres det nemmest ?
