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.
CODE
<?php
$con = mysql_connect("localhost","database_username","database_username_password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$con = mysql_connect("localhost","database_username","database_username_password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
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.
CODE
mysql_select_db("userbase_name", $con);
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.
CODE
$result = mysql_query("SELECT * FROM members ORDER 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.
CODE
echo "<table border='0'>
<tr>
<th>UserName</th>
<th>ID</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['UserName'] . "</td>";
echo "<td>" . $row['ID'] . "</td>";
echo "</tr>";
}
echo "</table>";
<tr>
<th>UserName</th>
<th>ID</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['UserName'] . "</td>";
echo "<td>" . $row['ID'] . "</td>";
echo "</tr>";
}
echo "</table>";
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.
CODE
mysql_close($con);
?>
?>
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.
I didn't understand because it was sooo basic 
Cool 