chong

Anonymous
So I put thiese lines on "lib-custom.php"

function phpblock_whos_new() { global $_CONF,$_TABLES; // Set the number of new members to show $numToShow = 5; $result = DB_query("SELECT uid,username,photo FROM ORDER BY regdate DESC limit $numToShow"); $nrows = DB_numRows($result); for ($i = 1; $i ' . $A['username'] . ''; if (!empty($A['photo']) AND $_CONF['allow_user_photo'] == 1) { $retval .= ' '; } $retval .= '
'; } return $retval; }
but it seems there's a trouble with "FROM ORDER BY"... I can't find how to fix it! need some help!!! thanx

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
It should read

FROM {$_TABLES['users']} ORDER BY

I also fixed Tony's original post.

bye, Dirk

chOng

Anonymous
yeah!!!!
now it works well!
thank you very much