What is the last (or first) child in physical order?

[opalepatrick]

$pages->find('parent=/blog/')->last();

This finds the last child by id order, but how can I get the last or first child if I order them by moving them in the admin list of child pages? Basically I want to choose a post to promote maybe by moving the post to the top or bottom of the list of posts in admin.

Thanks

PS. I know I could choose the id, but I don't really want to have to change the template every time.

[teppo]

If you want results in a specific order, use "sort":

$pages->find('parent=/blog/, sort=sort')->last();

// and if you want just one item, don't forget limit
// (or use get(), and check viewability separately)
$pages->find('parent=/blog/, sort=sort, limit=1')->last();

[Mats]

Or you could use: 

$pages->findOne($selector)

[opalepatrick]

Thanks Teppo, that was bang on. Thanks Mats, didn't know that one either.

[Soma]

get(selector) does a findOne(selector);

findOne(selector) does a find(selector)->first();

$pages->get('parent=/blog/, sort=sort')