Showing Data Records

David03

Okay, I have a page that allows users to register and inputs their data into my selected database, but I want to know now how I can view that data. What I want to do is have a members list like the PHPBB board does. I have member names, member_id (basic int values), and some other data. How would I use PHP/MySQL to print off the first like 5 users? I know it is something like.

select id, user_name, from my_table;

bbreslauer

You should check out the MySQL documentation at http://dev.mysql.com/doc/. It's very accessible, and fairly easy to understand. Specifically, you're looking for the SELECT sytax page at http://dev.mysql.com/doc/mysql/en/select.html

The general form of the SELECT query is what you have above.

David03

Okay, thanks.

I got this much:

SELECT LastName, FirstName FROM $database
ORDER BY FirstName

So I've got the table ordered alphabetically by users' first name. Now how would I print this to the screen? I've heard some use the while statment but I have no clue how to use it. Could someone give me a quick sample of how to print the records?

bbreslauer

$sql = your sql query;
$query = mysql_query($sql);

for ($i=0;$i<($result=mysql_fetch_assoc($query));$i++) {
    echo "Lastname: ". $result['Lastname'];
}

There are a bunch of mysql functions in php (take a look at the PHP manual at www.php.net) which are all mysql_fetch_[something]. The mysql_fetch_assoc creates an associative array based on the query, and the for loop (similar to a while loop) basically goes through each record that is returned from the database.