Ordering News by Date - Dev Articles

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

April 26th, 2003, 11:07 PM

wAr-AnGeL

Forum Security

Join Date: Apr 2002

Location: Behind You

Posts: 479

Time spent in forums: 6 m
Reputation Power: 7

Ordering News by Date

I have a news script I coded myself and I want to be able to have all news for one day to be grouped together. It would be like:

Quote:

Saturday, April 26, 2003
All news items for April 26th

Friday, April 25, 2003
All news items for April 25th

Any idea how I can do this? Thanks.

__________________

"Only Linux users see the end of crashes."
- Pl4t0

April 26th, 2003, 11:37 PM

jpenn

Contributing User

Join Date: Oct 2002

Location: Washington, DC

Posts: 317

Time spent in forums: 2 m 3 sec
Reputation Power: 6

How do you have the date stored in the DB? Show the format...

__________________
~ Joe Penn

We work for free to help make this a valuable resource on the internet. Do you appreciate the help - did we provide help that will help you prosper and help that has contributed to sharpening your current skill set?

Show your appreciation and purchase something from our Amazon Wishlist's - it's simple and a great way to say thank you.

April 26th, 2003, 11:51 PM

wAr-AnGeL

Forum Security

Join Date: Apr 2002

Location: Behind You

Posts: 479

Time spent in forums: 6 m
Reputation Power: 7

i do:

PHP Code:


		
			
 $now = time();

and insert that into a varchar(11)

April 27th, 2003, 12:08 AM

jpenn

Contributing User

Join Date: Oct 2002

Location: Washington, DC

Posts: 317

Time spent in forums: 2 m 3 sec
Reputation Power: 6

Ok - then what you need to do is first take the date that is chosen by the user to view the news on that day and convert it into a unix timestamp, then create your cutoff date by adding a day to the value - then select inbetween the two ->

PHP Code:


		
			
/*****************************

Convert The Date To Timestamp

*****************************/

$news_date_start = strtotime( /* The Selected User Date Scalar */ );

$news_date_end = $news_date_start + ( int )86400;

/*****************************

Build Query

*****************************/

$query = "SELECT whatever FROM table WHERE news_date > '$news_date_start' AND news_date < '$news_date_end'";

/*****************************

Hit It

*****************************/

$result = mysql_query( $query, $resource_id ) or exit( 'Invalid Query: ' mysql_error() );

/*****************************

Build Result Set

*****************************/

if ( mysql_num_rows( $result ) )

{

    while( $res = mysql_fetch_object( $result ) )

    {

        /* Build Result Set For Output */

    }

}

else

{

    echo( 'No results were found for that day.' );

}

Make sure on your html form that the dates are in a standardized format (without time) so strtotime() doesn't have any problems with the conversion...

April 27th, 2003, 01:15 AM

wAr-AnGeL

Forum Security

Join Date: Apr 2002

Location: Behind You

Posts: 479

Time spent in forums: 6 m
Reputation Power: 7

I think you may have misunderstood me. I want to show all news but group them by date, not select one day. Sorta like how www.unrealistic.net has their news grouped by date.

April 27th, 2003, 02:24 AM

jpenn

Contributing User

Join Date: Oct 2002

Location: Washington, DC

Posts: 317

Time spent in forums: 2 m 3 sec
Reputation Power: 6

Ok - grab the results and build an array from the results, then loop and output the array:

PHP Code:


		
			
 $query = "SELECT whatever FROM table ORDER BY date_column DESC";

/*****************************

Hit It

*****************************/

$result = mysql_query( $query, $resource_id ) or exit( 'Invalid Query: ' mysql_error() );

/*****************************

Get Results

*****************************/

$i = ( int )0;

while( $res = mysql_fetch_object ) )

{

    /*****************************

    Use Converted Tstamp For Key

    *****************************/

    $k = date( 'd F Y', $res->date_column );

    /*****************************

    Build Array

    *****************************/

    $dataset[$k][$i]['title'] = $res->news_title_column;

    $dataset[$k][$i]['news'] = $res->news_post_column;

    $dataset[$k][$i]['stamp'] = $res->date_column;

    /*****************************

    Increment Counter

    *****************************/

    $i++;

}

/*****************************

Loop And Output

*****************************/

foreach( $dataset as $key=>$val )

{

    $day = strtotime( $key );

    /***********************************

    Output Your Table Header Here

    ***********************************/

    echo( date( 'M j, Y', $day );

    /***********************************

    Now Loop Inner Array With Results

    ***********************************/

    foreach( $val as $post )

    {

        /***********************************

        Again, Table Crap

        ***********************************/

        echo( 'Posted On: ' . date( 'M j, Y h:i', $post['stamp'] ) . '<br />' );

        echo( $post['title'] . '<br />' );

        echo( $post['news'] . '<br />' );

    }

}

Untested and done quickly - but should give you what you want. Make sure you change your column names and sql stuff to reflect your DB structure...

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: