|
 |
Due to the volume of spam happening on our forums, posting is now restricted to verified members only. If you're not verified, drop us a note with your username.
|
|
Home > FlexCMS Support Forum > User Help > General Support Requests > SORTING NEWS BY TITLE
FlexCMS Support Forum
SORTING NEWS BY TITLE
Started August 10, 2006 @ 2:18pm by cberks
|
Post Message |
|
|
| SORTING NEWS BY TITLE | August 10, 2006 @ 2:18pm | Would it be possible to sort news articles by title when inserting into a page ie what woud be the field name to replace "datecode" with to sort by title
Code
$query_na = "SELECT * FROM `".$Settings['DBPrefix']."na-Articles` WHERE ApprovedBy!='' AND Category IN (".$CategoriesList2.") ORDER BY DateCode DESC LIMIT ".$LimitString; |
|
|
|
|
|
|
|
|
| |
DCSun
Administrator
Posts: 625 |
|
|
| August 10, 2006 @ 4:30pm | Chris,
Yes, that can certainly be done. The table field containing the article title is simply called "Title", so if you replace "DateCode" with "Title", and change "DESC" to "ASC" (unless you want them sorted from Z-A), that should do it for you.
David
FlexCMS v3.2 Has Been Released! |
|
|
|
|
|
|
| |
|
|
| link to single news item | August 10, 2006 @ 5:14pm | how would I write a link in a calendar entry to link to an individual news/article?
Regards, Chris
- by the way not only is your product great but your responsiveness is as well :=) |
|
|
|
|
|
|
| |
DCSun
Administrator
Posts: 625 |
|
|
| August 10, 2006 @ 5:21pm | Chris,
Thanks for the kind words about FlexCMS and our support.
I would just link directly to the URL of the news/article page. It'll be something like "http://www.domain.com/index.php/articles/view/69.html". That number won't change, so as long as the article is there (as in hasn't been deleted), that link will work fine.
David
FlexCMS v3.2 Has Been Released! |
|
|
|
|
|
|
|
|
|
| MEMBERS
|
|
|
