Keep an article at top of page

Hi,

Here perhaps a solution :
http://www.interactivetools.com/forum/gforum.cgi?post=58753#58753

Djulia

Thanks for jumping in, Djulia!

If you didn't need the specific control mentioned in the other tutorial, you could have a simple checkbox to "bump" news items to the top. In fact, when you create a new "News" section, it will have this done automatically!

For existing editors, all you need to do is create a new checkbox called "featured", then set the orderBy value in your viewer to sort by date, with any items with the "featured" checkbox set sorted first:

$options['orderBy'] = 'featured DESC, date DESC';

And for another neat trick, you can keep your contributors from making ALL their submissions featured by making that checkbox an "admin only" field. Go to the Section Editors menu, click "Modify" for News, and then "Modify" for your featured field. Under "Advanced Options", setting the field to Admin Only will mean that non-admins can't decide which articles are featured!

Posted at 10:43... Always just one minute ahead of me aren't you Theo? :)

You're slowing down now that you've hit 30, old man! Hah hah!

(...hope no one remembers that I'm 34...)

Once again thanks for the help. Your company is truly great when it comes to support. Thanks Again Glenn

Hi, Theo.

Please can you tell me where your line of code should go if I want to list headlines in reverse order, so that the newest ones are always at the top? I currently have this on my list page:

<!-- STEP2: Display Record List (Paste this where you want your records to be listed) -->
<?php foreach ($listRows as $record): ?>
<P><STRONG><A HREF="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></A></STRONG><BR/>
<I>Added <?php echo date("l j F Y", strtotime($record['date'])) ?></I></P>
<P>
<?php endforeach ?>
<?php if (empty($listRows)): ?>
<!-- Display "No Records Found" Message -->
No records were found!<BR/>
<BR/>
<?php endif ?>
<BR/>
<!-- /STEP2: Display Record List -->

Regards, Nigel

Hi Nigel,

In your 'orderBy' option just add 'DESC' after title. DESC is a MySQL keyword which means descending or reverse order. So it might look something like this:

$options['orderBy'] = 'featured DESC, date DESC';

Hope that helps, let us know if you need anything else.