[Guide] 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

[Facebook]

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.

[Facebook]

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