Ordering News by Date - Dev Articles

Dev Articles Community Forums Sponsor:

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 50 sec
Reputation Power: 8

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: 8

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 50 sec
Reputation Power: 8

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: 8

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 50 sec
Reputation Power: 8

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: 8

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...

Viewing: Dev Articles Community Forums > Programming > General Programming Help > Ordering News by Date

« Previous Thread | Next Thread »

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:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

Free IT White Papers!

Create the Optimal Architecture for your Critical Applications
Warburton's the largest independently owned bakery in the UK faced a number of difficult challenges in providing the most robust yet efficient IT infrastructure for their organization's success. IBM's services combined with their xSeries servers created the perfect platform for their SAP environment with sufficient flexibility, and did so in very time effective fashion.
Request Your Free Technology Downloads!

Five Best Practices for Deploying a Successful Service-Oriented Architecture
This white paper describes the benefits you can expect with SOA, and how IBM can help take your business there.
Request Your Free Technology Downloads!

Gartner Magic Quadrant for Application Delivery Controllers
Gartner summarizes its view on Application Delivery Controllers, evaluates strengths and weaknesses of solutions, and provides Magic Quadrant reporting for a quick comparison across all vendors. Learn from Gartner how you can benefit from an all-in-one device like Citrix NetScaler that delivers the highest levels of availability, performance and security.
Request Your Free Technology Downloads!

Knowledge is Power
What you don't know can hurt you, and is likely costing you money and increasing your security risks during an era of scarce resources. This white paper proposes six key strategies that enterprise security managers can use to improve their network defense posture.
Request Your Free Technology Downloads!

Rationalizing the Multi-Tool Environment
The rationalized multi-tool approach is flexible, scalable and cost effective. It provides the necessary input to the IT service management business processes. It preserves prior investments in monitoring tools, empowers technologists to select the best tools with which to do their jobs, and enhances effective response to incidents.
Request Your Free Technology Downloads!

More Free IT White Papers!