mysql_fetch_array in a while loop

[Anon]

i'm an intermediate level programer, but i'm just beginning with PHP\MySQL...

here's the basic layout

$Query = "Select * from conf_ymo ORDER DESC LIMIT 2)";
$Result = mysql_db_query($DBName, $Query, $Link);

while ($Row = mysql_fetch_array($Result)) {
$News = "<p class=caption>$Row[date] $Row[title]</p><br><p class=body>$Row[content]</p><br>";
}

I know this is amature but my problem is that the MySQL keeps booting the request as an error on the while loop line. I've read all a ton of forums and i just can't see my error. All the variable inside the mysql_db_query command work. I've got other queries which run & work on this page.

[amcgrath]

when you say "booting the request" what do you mean? what error are you getting? PLus, you realize that your code right now just overwrite the $News variable with whatever values in the latest loop info.... try $News[] = ....

[Anon]

I'm saying that when the php code runs the request i get an error. The specific error is: that the line on which the while loop is written returns an invalid result resource.

ryan

[amcgrath]

This line is all wrong: $Query = "Select from conf_ymo ORDER DESC LIMIT 2)";
try something like: $Query = "Select from conf_ymo ORDER BY <some_field> DESC LIMIT 2";