while løkke
hvad er det der er galt her den vil ikke udskrive Firma : ".$row2['firma']."mysql_connect("localhost", "xxxxxx", "xxxxxx");
mysql_select_db("xxxxxx");
$res = mysql_query("SELECT * FROM ordre WHERE status = '0'");
$count = mysql_num_rows($res);
if($count == 0)
{
echo "Der er opstået en fejl.";
}
else
{
while($row = mysql_fetch_array($res))
{
$res2 = mysql_query("SELECT o.*, k.firma FROM ordre o INNER JOIN kunde k ON o.kundenr = k.kundenr");
while($row2 = mysql_fetch_array($res2))
{
echo
"
<table width=100% border=0 cellspacing=0 cellpadding=0 class=text>
<tr>
<td width=18%>kunde nummer</td>
<td width=82%>".$row['kundenr']."</td>
</tr>
<tr>
<td>Firma</td>
<td>".$row2['firma']."</td>
</tr>
<tr>
<td>vare</td>
<td>".$row['vare']."</td>
</tr>
<tr>
<td>leverings dato</td>
<td>".$row['dato']."</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td width=17%><a href=ordre.php?mode=afslut>Afslut ordre</a></td>
<td width=83%><a href=ordre.php?mode=selt>Slet ordre</a></td>
</tr>
</table></td>
</tr>
</table><br>";
}
}
}
}
?>
