Sort Options

[scottdallas]

I don't know about anyone else but even if this is posted only for my resource later, that's fine. I'm sure Google will pick this up. I'm always forgetting which to use... ASC or DESC for my sort options and I usually end up using 6 different ways.. so I wrote them all down for safe keeping so I could use over and over and never forget. Here it is:



Newest to Oldest

$sort = array('date', 'DESC');



Oldest to Newest

$sort = array('date', 'ASC');



Most Views to Least Views

$sort = array('views', 'DESC');



Least Views to Most Views

$sort = array('views', 'ASC');



Most Comments to Least Comments

$sort = array('comments', 'DESC');



Least Comments to Most Comments

$sort = array('comments', 'ASC');



If anyone thinks that this is a waste of a post, my feelings wont be hurt if you delete it.

[scottdallas]

Updated list:

Newest to Oldest
$sort = array('date', 'DESC');

Oldest to Newest
$sort = array('date', 'ASC');

Most Views to Least Views
$sort = array('views', 'DESC');

Least Views to Most Views
$sort = array('views', 'ASC');

Most Comments to Least Comments
$sort = array('comments', 'DESC');

Least Comments to Most Comments
$sort = array('comments', 'ASC');

Alphabetical (A-Z)
$sort = array('title', 'ASC');

Alphabetical (Z-A)
$sort = array('title', 'DESC');

Sort By Date (Today)
$year = date('Y');
$month = date('n');
$day = date('d');

Most Viewed Posts (30 Days)
$mktime = (time() - 3600 * 24 * 30);
$year = date('Y', $mktime);
$month = date('m', $mktime);
$sort = array('views', 'DESC');

Sorting By Date & Time:
$year = date('Y');
$month = date('n');
$day = date('d') - 1;
$sort = array('comments', 'DESC');

Sort by author name:
$author = "username";

[Partyism]

sorry for kicking this old topic but DESC or ASC is not working for me

Code: Select all

<?PHP
                  $schedule = true;
                  $sort = array('date', 'ASC');
                  $static['template'] = 'Evenementen';
                  $static['number'] = '3';
                  $static['category'] = '20';                  
                  i

[Torstein]

you need to use

Code: Select all

$static['sort'] = array('date', 'ASC');

since the rest are static variables.

[Partyism]

i know.. stupid me... hmmprff

thnx for your help!

[nam]

Updated list:
Most Viewed Posts (30 Days)
$mktime = (time() - 3600 * 24 * 30);
$year = date('Y', $mktime);
$month = date('m', $mktime);
$sort = array('views', 'DESC');

This does not work for me, trying since long but it still shows overall articles sorted by view count regardless of its date.

On database level, the following SQL query on the table gives me the exact output I need:

Code: Select all

SELECT `title`
FROM `ru_news`
WHERE DATE_SUB( CURDATE( ) , INTERVAL 30
DAY ) <= FROM_UNIXTIME( date )
ORDER BY `views` DESC
LIMIT 0 , 10;

[nam]

I found the problem.

Actually $time was set as false ($time = false;) in my show_news.php file. When removed that line, now it works fine.

[Ramon]

If you want to sort on multiple fields..

Code: Select all

$sort = array('category', 'ASC', ',', 'title', 'ASC');

with this you can achieve a result like this -> http://fminside.nl/teams/fm2010/

It first sorts on the column "comp" and then on "naam"..

[typeman]

Updated list:
Most Viewed Posts (30 Days)
$mktime = (time() - 3600 * 24 * 30);
$year = date('Y', $mktime);
$month = date('m', $mktime);
$sort = array('views', 'DESC');

Guess what... it's not working for me either. I checked my "show_news.php" file to see if $time = false, but i couldn't even find that file... Can someone please help me?

Thanks XD

[typeman]

Can anyone help? Thanks for your help!

[kini]

sorry for the offtopic ...
do you know how i can sort by title???
thanks

[eberswine]

Code: Select all

Alphabetical (A-Z)
$sort = array('title', 'ASC');

Alphabetical (Z-A)
$sort = array('title', 'DESC');

[kini]

thanks so much for your answer!!
but it not runs... i don't know why

needs some *.mdu modification??
i'm using the cutenews standar not the cutenews ru

<?PHP
$category = "1";
$sort = array('title', 'ASC');
include("cutenews/show_news.php");
?>

thanks!

[kini]

ok! finally i find the answer here
http://cutephp.com/forum/index.php?showtopic=3733
thanks for your support!!!!