mysql_fetch_array() error

[generic]

Hey folks, this is blowing my mind. I can't see what's wrong with this...

$query = mysql_query("SELECT title, body FROM $prefix" . "news ORDER BY id desc LIMIT 0 1");

while ($row = mysql_fetch_array($query)) {
$title = $row["title"];
$body = $row["body"];

I keep getting this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource...

Can anyone help out or am I leaving out too much? Tnx!

-gen

[robryals]

It looks like your query is failing and the $query is not a valid result set. It looks like you need a comma on the LIMIT caluse between 0 1

[trooper]

At the end of you $query line put

   or die(mysql_error());

HTH

GM