E
03-23-2002, 03:37 AM
Ok this is what i have
---------
Open up your index.php file and find the following
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=number_format($numbersmembers['users']);
Under That ADD:
// Richest Member
$richestmem=$DB_site->query_first("SELECT username,dopeness,userid FROM user ORDER BY points desc LIMIT 1");
^^in there Dopeness is my point field value..... replace it with yours...
Now open up the Forumhome template and add this code whereever you want it
#################
<a href="member.php?&action=getinfo&userid=$richestmem[userid]\"><b>$richestmem[username]</b></a>($richestmem[dopeness])
#################
Once again replace dopeness with your field name....
PEACE
-------
Ok... I need Help cuz i need too run a query or something thru the MYSQL too make the column dopeness For my 6th field.. unless there is another way too do this :)
---------
Open up your index.php file and find the following
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=number_format($numbersmembers['users']);
Under That ADD:
// Richest Member
$richestmem=$DB_site->query_first("SELECT username,dopeness,userid FROM user ORDER BY points desc LIMIT 1");
^^in there Dopeness is my point field value..... replace it with yours...
Now open up the Forumhome template and add this code whereever you want it
#################
<a href="member.php?&action=getinfo&userid=$richestmem[userid]\"><b>$richestmem[username]</b></a>($richestmem[dopeness])
#################
Once again replace dopeness with your field name....
PEACE
-------
Ok... I need Help cuz i need too run a query or something thru the MYSQL too make the column dopeness For my 6th field.. unless there is another way too do this :)