Opdater Databasen med udregnede værdier.
Daus Igen !har denne kode:
<?
echo "
<head>
<title>Nyhed !</title>
<meta http-equiv=\"Content-Language\" content=\"da\">
<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 5.0\">
<meta name=\"ProgId\" content=\"FrontPage.Editor.Document\">
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">
<LINK rel=\"stylesheet\" HREF=\"netstationen.css\" type=\"text/css\">
</head>";
@mysql_connect("localhost","root","");
@mysql_select_db("faktura");
$hent= mysql_query("SELECT * FROM kunde WHERE id=$_GET[id]");
$udskriv = mysql_fetch_array($hent);
echo"
<br><br><br><br><br>
<body>
<fieldset style=\"width: 412; height: 98\"> <legend> Kunde </legend>
<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"383\" height=\"65\" id=\"AutoNumber1\">
<tr>
<td width=\"152\" height=\"23\"> Navn</td>
<td width=\"225\" height=\"23\">$udskriv[navn]</td>
</tr>
<tr>
<td width=\"152\" height=\"4\"> Adresse</td>
<td width=\"225\" height=\"4\">$udskriv[adresse]</td>
</tr>
<tr>
<td width=\"152\" height=\"13\"> Post Nummer:</td>
<td width=\"225\" height=\"13\">$udskriv[post]</td>
</tr>
<tr>
<td width=\"152\" height=\"18\"> Telefon:</td>
<td width=\"225\" height=\"18\">$udskriv[tlf]</td>
</tr>
</table>
</fieldset> <fieldset style=\"width: 50; height: 0\">
<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"175\" height=\"0\" id=\"AutoNumber1\">
<tr>
<td height=\"23\">Dato</td>
<td height=\"23\">$udskriv[date]</td>
</tr>
<tr>
<td height=\"4\">Faktura Nummer</td>
<td height=\"4\">2006-$udskriv[id]</td>
</tr>
</table>
</fieldset>
</body>
";
echo "
<div align=\"left\">
<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#C0C0C0\" width=\"698\" height=\"22\" id=\"AutoNumber1\">
<tr>
<td width=\"131\" height=\"22\">
<p align=\"center\"><b>Antal</b></td>
<td width=\"346\" height=\"22\">
<p align=\"center\"><b> Varebetegnelse</b></td>
<td width=\"139\" height=\"22\">
<p align=\"center\"><b>Unit Price</b></td>
<td width=\"72\" height=\"22\">
<p align=\"center\"><b>Beløb</b></td>
</tr>
</table>
</div>
";
$hent5= mysql_query("SELECT * FROM bvare WHERE mail='$udskriv[mail]'");
while($vare = mysql_fetch_array($hent5)){
echo "
<div align=\"left\">
<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#C0C0C0\" width=\"698\" height=\"22\" id=\"AutoNumber1\">
<tr>
<td width=\"131\" height=\"22\">
<p align=\"center\">$vare[antal]</td>
<td width=\"346\" height=\"22\">
<p align=\"center\">$vare[betegn]</td>
<td width=\"139\" height=\"22\">
<p align=\"center\">$vare[oneprice],-</td>
<td width=\"72\" height=\"22\">
<p align=\"center\">
";
$tal = $vare[antal] * $vare[oneprice];
echo $tal;
mysql_query("UPDATE bvare SET total='$tal' WHERE mail=$vare[mail]");
echo "
</td>
</tr>
</table>
</div>
";
}
$test = mysql_query("SELECT * FROM bvare WHERE mail='$udskriv[mail]'");
$test2 = mysql_num_rows($test);
if($test2>0){
$test = mysql_query("SELECT * FROM bvare WHERE mail='$udskriv[mail]'");
while($test2 = mysql_fetch_array($test)){
}
}
?>
undskyld hvis den er lidt roddet, men Ja ..
den linie her:
mysql_query("UPDATE bvare SET total='$tal' WHERE mail=$vare[mail]");
vil jeg gerne have til at opdatere de valgte vare som den regner ud, men den opdatere de rigtige varer, men sætter TOTAL til at være den værdi som er regnet ud sidst ? hvordan får jeg den til at opdatere hver enkelt felt med det den regner ud ? hvis i forstår ..
