sort by date

[MatrixGL]

well, i am writing this script similar to news script

Every entry in the table (mysql database) has a an int column that holds an unix timestamp (generated by php).

Now, what I want to do is, display the news articles by date on the site.

Like for example:

17th May 2005

First news
Second News

16th May 2005

First news
second news.

Now, there might not be any news posted in some days, and it'll display all the news at once.

How do I acomplish that?

Thanks.

[bpat1434]

<?php

$query = "SELECT * FROM table ORDER BY date_column DESC";
$result = mysql_query($query);
$curdate = '';

while($row = mysql_fetch_array($result))
{
    if($cur != $row['date_column'])
    {
        $cur = $row['date_column'];
        echo date("jS M Y", $row['date_column']).'<br>';
        echo '------------<br>';
    }
    echo $row['column_name'].'<br>';
}

?>

~Brett

[MatrixGL]

worked like a charm 🙂....thank you very much 🙂

[bradgrafelman]

Don't forget to MARK THIS THREAD RESOLVED using the link at the bottom of the page if you did indeed find a solution to your issue.