supplied argument is not a valid MySQL result reso

[borki]

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

[ryanlwh]

your query probably just return nothing (but syntatically correct). try it out in phpmyadmin. also, do this

 $rabatt=mysql_query($strSQL) or die(mysql_error()); 

[borki]

Hey, thx a lot for your help!

 

I almost don't dare say what the problem was cause it's just a n00b error:

 

"No database selected" LOL Now everything works...

 

cu