Weird mysql_fetch_array problem

[dar-k]

This piece of code:

$query = "select * from Bestellingen where ID = $id"; 
$result = mysql_query($query) or die(mysql_error()); 
$off = mysql_fetch_array($result); 
foreach($off as $key => $value){echo "$key = $value<br>";} 

Gives me this error:

Warning: Invalid argument supplied for foreach() in /home/sites/site204/web/structure/offerte.php on line 14

Does anyone see anything I missed? mysql_query didn't give any errors...

[Anon]

Try to make it simpler (but longer in coding :-))

$query = "SELECT field FROM table";
$rows = mysql_num_rows($query);
for($i=0;$i<$rows;$i++){
$result=mysql_result($query,$i,"field");
}

This is the way i do it, and ir NEVER fails. At least, if the query is allright.

fLIPIS