Forgot Password / Register
Site Statistics
Total Members: 520
Total Tutorials: 242
Newsest User: 8884244477
Todays Unique Hits: 377
0 Users 4 Guests Online
Forum Index » PHP + MySQL » [Help]
Posted on Friday 13th July 2007 at 09:23 PM
gbt91
templates/default/images/noavatar.png's Avatar
Junior Member
I Have this code
[CODE]
$getnews = mysql_query("SELECT * FROM news ORDER BY id ASC LIMIT $from, $max_results");
[/CODE]
but this show the first news at the top of the page, i want it the opposite way..the top must display the newest news...
Posted on Friday 13th July 2007 at 09:30 PM
ShadowMage
templates/default/images/noavatar.png's Avatar
Senior Member
instead of ASC put DESC
Posted on Friday 13th July 2007 at 10:17 PM
gbt91
templates/default/images/noavatar.png's Avatar
Junior Member
great