how to make a userlist with php

[smiegles]

Hello people,

Here a tut how to make a user list with php.
First whe just start with

<?php

?>

really simple.
now whe make a query

<?php
$userlist_query = mysql_query("SELECT * FROM users");
?>

yup really simple
now whe get the data as a object and whe order the users by id

<?php
$userlist_query = mysql_query("SELECT * FROM users ORDER BY id DESC");
$get_users = mysql_fetch_object($userlist_query);
?>

so the query is done and now whe al get the data by a while like this

<?php
$userlist_query = mysql_query("SELECT * FROM users ORDER BY id DESC");
while($get_users = mysql_fetch_object($userlist_query)) {
echo $get_users->username;
echo '<br />';
}
?>

that is al
dont forget to include your config.php
it can i make a mistake i dont tested it ;x
it can i make a bad english text i am hollands

greats ,
Smiegles

 

[Danny]

Nice,

But this should be in the coding section.

 

[smiegles]

no it is for UberCms and phpoenix <3

 

[George2000]

no it is for UberCms and phpoenix <3

It can be done for each cms though, so it must be in the coders paradise section. Also this is good for noobs, which can't script in PHP.

 

[Danny]

Oh i see didn't know that. Nice job.