browse.php show new members first?

How can i get my browse.php to shom my new members first or the lastest members registered or online?

Yes me too!  I like how all photos line up on the first page.  That's very exciting but not so exciting after seeing the same people on the first page over and over.  is there a way to show new photos first, not last?

I know where is it but not sure how to fix it.  Here's the code I have now.

$profiles_list_query = "SELECT `ID`, `NickName`, `Sex`, `DateOfBirth`, `Couple`, `DateReg` FROM `Profiles` WHERE {$sql_add} AND `Profiles`.`Status`='Active' ORDER BY `Couple` ASC, `Picture` DESC LIMIT {$real_first_p}, {$p_per_page}";

Any ideas?

Thanks!

this one is easy files to edit

/templates/base/scripts

BxBaseBrowse.php

on line 671

$sSortParam = '`Profiles`.`DateLastLogin` DESC';

change to

$sSortParam = '`Profiles`.`DateReg` DESC';

that should do it :D

upsss sorry the fix is for d7 only

 Try this:

$profiles_list_query = "SELECT `ID`, `NickName`, `Sex`, `DateOfBirth`, `Couple`, `DateReg` FROM `Profiles` WHERE {$sql_add} AND `Profiles`.`Status`='Active' ORDER BY `Couple` DESC, `Picture` DESC LIMIT {$real_first_p}, {$p_per_page}";

Thanks.  I found a solution for D6.  I simply added `id` DESC  and that's it.  

wow thanks for your quick replies.   adding `id` DESC  works great.

$profiles_list_query = "SELECT `ID`, `NickName`, `Sex`, `DateOfBirth`, `Couple`, `DateReg` FROM `Profiles` WHERE {$sql_add} AND `Profiles`.`Status`='Active' ORDER BY `Couple` ASC, `Picture` DESC, `id` DESC LIMIT {$real_first_p}, {$p_per_page}";