Hello,
can anyone plz have a look at my sourcecode? I do not find the error:
<?
$strSQL="SELECT customers.rabatt FROM customers INNER JOIN orders ON customers.firma = orders.firma WHERE orders.order_id=".$rechnung;
$rabatt=mysql_query($strSQL);
while ($Zeile=mysql_fetch_array($rabatt));
{
echo "<option value=".
"\"$Zeile[0]\">$Zeile[0]</option>";
}
$rab= $Zeile[0] * $rabatt;
echo $rab ?>
The error is message is:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/...
Thx for your help