Create the page just like the signup, except set the value of the text boxes to the result from the database. Then, when the user clicks submit, use an UPDATE query to update the appropriate fields with the values entered in the text boxes.

set a condition on the page where the user can only edit their own profile (must be signed in).

ok i changes it around a bit
i just added columns into the members table
it was a lot easier on me when i did that
so now with that done how would i set variables on a profile page
where when i link to a profile the link looks like this
"http://d omain.com/blahb lah.php?member= Admin"
and in the page all the content will be pulled out of Admin's row

Like bs0d mentioned, make it so that the user has to be logged in. Then from his/hers own profile page they would have an option to edit their profile. The page that would display their information would check to see if they are logged in first, then using the session name, would compare that to the username in the DB and then retrieve those values and populate the form with it.

Once the values in the form have been changed, then you send an UPDATE query back to the username in the DB and update the new information.

So your url would look something like this:

<a href="edi t_profile.php?m ember=<?php echo $_SESSION['use rname']; ?>"> ;Edit Profile</a&g t;

If the user is logged in, then the session name variable will appear in the URL. Just make sure that sessions are used to control that page so that you can't just spoof the username in the url and access their account.

i have done the edit profile part and all of it works perfect but now what i want to do is make a page where other members can view your profile. I as thinking of nameing viewprofile.php and it want it to call the members username variable in a link like this "viewprof ile.php?member= Admin" and the sql query will get information from Admin's row. How would i set the variables to work like that?

In that case, you would use $_GET['member ']. You use $_GET to get variables from the URL. Also, be careful when allowing visitors to dictate what will be used as a variable in your queries. Validate the input before continuing with your query to be safe.