Im trying to display a users details, but I don't know how to display the users details with their id.

PHP Code:

mysql_connect("localhost","-","-");
mysql_select_db("-");

$result = MYSQL_QUERY("SELECT * FROM users");
$worked = mysql_fetch_array($result);

$username = $worked[username];

echo "<h1>View Information</h1>\n";
echo "Username: $username<br \>\n"; 


That's what I got so far but how $username be the username from id say 6? So far it only displays id 1 information which is mine. Any help?

If you change your query to something like this:

SELECT * FROM users WHERE id='6'

Then it should do what you want. Obviously, "id" is the column name, and you could change the "6" to be a variable, which can be defined in your script.

I had to do it by username, I didn't want to do that in the first place because I haven't made my register page detect if their is already a user with that name or not.

PHP Code:

if (session_is_registered('username') == true) {
mysql_connect("localhost","-","-");
mysql_select_db("-");

$result = mysql_query("SELECT * FROM users WHERE username='$username'");
$row = mysql_fetch_row($result);

echo "Username: $row[1]<br \>\n";   
echo "E-mail: $row[3]<br \>\n";
echo "Website: $row[4]<br \>\n";
echo "MSN: $row[5]<br \>\n";
echo "Yahoo!: $row[6]<br \>\n";
echo "ICQ: $row[7]<br \>\n";
echo "Location: $row[8]<br \>\n";
echo "Occupation: $row[9]<br \><br \>\n"; 


I set the username session from the login page, and on the login page you don't put your id in so I couldn't add it to the session.

Ok, but it is working now, though?

You tell me
http://host.inc.md/
Oh, and yes it is working. But still... I would have prefered it be by user's id instead of username.

Ahh k, thats good. Just remember, you can always use it with ID by changing the WHERE to id='$id'

But how do I define $id? I can't... well I can, but don't know how.

get it from the database is the obvious one

in your second example it would be $row[0] depending on the order of columns in your table and assuming id is the first column.