Alright, some of you might want to display your User's or Members on your site.

Notes:
1.This is to fit in with Feelay's register and Log-in scripts you can find in the tutorial section.
2.I made this to show the members of my site who is a member and what their ID is.



First off, we must set up a connection to our MySQL Database.

What it does:
1.It is starting a PHP document.
2.Next it sets up a connection to the database with the members table.
3.Change 'database_username' to your database username.
4.Change 'database_username_password' to your username's password.

Next, we select the database the information is stored at using the 'mysql_select_db() function.

What it does:
1.All it is doing is selecting a database using the connection in the first part of code.

For the next part, we will be selecting the table in which the members info is stored at, whereas the table is named 'members'.
And you want to order them by ID.

What it does:
1.The '$result', is just a variable, so you don't have to type the function again.
2.It is selecting everything '*', from the table members and ordering it by the user's ID.

For the third part, we will be creating a HTML table to display the user information.

What it does:
1.You can can change the '0' in the <table border=''> tag to anything you chose.
2.The '<th>User Name</th>'&'<th>ID</th>' tags are the top of the table.
3.The 'while() function is creating an array, whereas '$row' is a variable to shorten your work, instead of typing the mysql_fetch_array() function out again.
4.The 'echo "<td>" . $row['UserName'] . "</td>";' & ' echo "<td>" . $row['ID'] . "</td>";' is just selecting the info from the table to be displayed, whereas the user/members name is stored in the column 'UserName' and the ID is stored under 'ID'.

Ending your document.

What it does:
1.It is closing the connection we made in the first part of this tutorial.
2.It is closing the <?php tag in the first part of code of this tutorial.

The Output
User Name ID
User1 1
User2 2
User3 3
User4 4
etc. etc.


That's it!
Any questions, feel free to ask.
This is my first tutorial on Astahost forums.

Nice tutorial, Archimedes. I appreciate the way you use simple words in order to explain rather complicated things (using php to make queries into the database and displaying the results on the screen). Lucky strike for a first tuto, I hope that you will continue this way.
Regards
Yordan

Thank you, Yordan, I plan to have many more tutorials in the future! xD

lol xD this is too basic I didn't understand because it was sooo basic
haha almost kidding this is very basic ^.^ haha, making it fit with my login/register scripts Cool