[ChunkyTeXas]

Hey guys,

I have a simple, no frills posting script and I have one problem. When I post something, the newest post goes under the last post, instead of the newest going on top of the older post. I know its an easy fix, I just can't remember the appropriate code =)

PHP Code:

<?php
include ('mysql_connect.php');
$query = "SELECT id, title, author, post, last, DATE_FORMAT(date, '%M %d, %Y') as sd FROM news_posts";
$result = @mysql_query($query);
 
if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$url = 'comments.php?id='.$row['id'];

?>

[anlore2001]

Try

ORDER BY post Desc

at the end of your SQL statement which will order it by the post in decending order. If you want to sort it by something else, just replace "post" with another field.

[ChunkyTeXas]

ty!

[anlore2001]

Anytime