[kall]

Originally Posted by 1996 328ti

Again, is it possible to sort by username and is it possible to make this block run in 2 columns?

Probably.

Change

PHP Code:

WHERE subscriptionlog.status = '1' ORDER BY regdate DESC LIMIT 10
    "); 


to

PHP Code:

WHERE subscriptionlog.status = '1' ORDER BY username DESC LIMIT 10
    "); 


That's just me looking at it and doing the completely obvious thing of swapping regdate for username...I haven't tested it, but as I say, it's obvious, so it should work.

Just in case it crops up, swap DESC to ASC if you want the order reversed and LIMIT 10 to LIMIT * (where * is the number you want to display).

As for the columns, I wouldn't know. HTML is the devil.