Members Database

[darthpaul]

YaBB SE Version: 1.5.4
PHP Version: 4.3.2
MySQL Version: 4.0.x
Server Platform: Unix, Linux, or BSD
Link to Forum: http://www.fishcrazy.co.uk/forum/index.php

Problem Description:
When you view the member list on yabb by default the all list seems to take the default order of the members database. At some point my members default order seems to have been resorted alphabetically.

When I do a browse on phpMyAdmin the first order it shows is how it displays on the memberlist. Is there anyway I can re-order the database so it always shows in registered date order which is how it originally displayed a long time ago.

[[Unknown]]

Find:
$query = "SELECT memberName,realName,websiteTitle,websiteUrl,posts,memberGroup,ICQ,AIM,YIM,MSN,emailAddress,hideEmail,ID_MEMBER FROM {$db_prefix}members WHERE 1 LIMIT $start,$MembersPerPage";

Replace:

$query = "SELECT memberName,realName,websiteTitle,websiteUrl,posts,memberGroup,ICQ,AIM,YIM,MSN,emailAddress,hideEmail,ID_MEMBER FROM {$db_prefix}members WHERE 1 LIMIT $start,$MembersPerPage ORDER BY dateRegistered";

-[Unknown]

[darthpaul]

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY dateRegistered' at line 1
File: /home/darthp/public_html/forum/Sources/Memberlist.php
Line: 327

Anyone any clues why just adding an order cause this error?

[[Unknown]]

I'm an idiot.  I meant:

$query = "SELECT memberName,realName,websiteTitle,websiteUrl,posts,memberGroup,ICQ,AIM,YIM,MSN,emailAddress,hideEmail,ID_MEMBER FROM {$db_prefix}members ORDER BY dateRegistered LIMIT $start,$MembersPerPage";

-[Unknown]