If you have in mind an username that you want to promote, I think it would be easier to simply enter the username instead of sifting through a lengthy list of users.
Regarding the query to create a user list, first you have to have a table in the database with the data elements of each user. Usually this table is called 'users_PREFIX' or 'members_PREFIX' (depending on the cms used). Check for that table, you should work on the index.php file of the form / page you wish to include as an anchor member list. I'll give you an example a little more concrete:
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
FROM user_table
ORDER BY desired_value;
Makes the idea? Then you should have at least a smattering of php and html page to insert into a template or otherwise create a graphic in which to insert the information obtained by the SELECT command.
But if you want to opt into something more comfortable, I suggest you seek or add-on modules suited to your CMS. Usually a form already exists for all creation which makes this function of the user list without having to create everything from scratch, and then you avoid all the hack on the code.
I would also like to encourage the developers to create a user administration page for administration of current users. Also to be able to manually add users. also to have the option of administratively confirming newly registered users. I would like to be able to delete/remove users from within diferior without having to manually mess with the database.
Comments: 6
Forum posts: 58
Added downloads: 2
Comments: 18
Forum posts: 573
As for adding administrators, you can already do that.
Comments: 6
Forum posts: 58
As for adding administrators, you can already do that.
I realize that. But I meant add administrators from a members list. It would just seem easier.
Added downloads: 2
Comments: 18
Forum posts: 573
Comments: 1
Forum posts: 85
Regarding the query to create a user list, first you have to have a table in the database with the data elements of each user. Usually this table is called 'users_PREFIX' or 'members_PREFIX' (depending on the cms used).
Check for that table, you should work on the index.php file of the form / page you wish to include as an anchor member list.
I'll give you an example a little more concrete:
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar FROM user_table ORDER BY desired_value;
Makes the idea?
Then you should have at least a smattering of php and html page to insert into a template or otherwise create a graphic in which to insert the information obtained by the SELECT command.
But if you want to opt into something more comfortable, I suggest you seek or add-on modules suited to your CMS. Usually a form already exists for all creation which makes this function of the user list without having to create everything from scratch, and then you avoid all the hack on the code.
I hope to be state helpful ...
See you soon.
Forum posts: 378