mysql_query() function help

[electricocean]

$posting=mysql_query("select * from news where firstname like 'eli'");

how would I change the mysql_query() function to select the 10 news entries from newest to oldsest?

[coopster]

SELECT * FROM news ORDER BY mydatefield DESC LIMIT 10;