PHP - Moved: Order By Desc Limit 1 Help

Glad to be back in the community 

Anyways I've got a mysql table with 4 different entries from a form.  One being an id with an auto-increment.  I'm wanting to arrange them into a table, descending by the id number.  I'm having a hard time wrapping my mind around how to even start it and get the other 3 fields to retrieve and be in a table together.  I have:

$db="prayers";
$link = mysql_connect('localhost', 'root' , '');
if (! $link) die(mysql_error());
mysql_select_db($db , $link) or die("Select Error: ".mysql_error());


$query = "SELECT * FROM table prayerwall BY id DESC LIMIT 10";  

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

Not sure how to retrieve the other entries and then put them into a table.  A start or some help would be greatly appreciated.  Thanks everyone!

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=323002.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=342142.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=354388.0

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=316294.0