Welcome to Geeklog Sunday, May 22 2022 @ 10:01 pm EDT

Geeklog Forums

Who's new


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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
It should read

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

I also fixed Tony's original post.

bye, Dirk
 Quote

chOng

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

All times are EDT. The time is now 10:01 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content