PHP member profile help
Moderator: General Moderators
PHP member profile help
I have a member management script on my site, but I was wondering how I can create a page for each of them as a profile? All of their information is stored in a table by mySQL, but I don't know how to show it in a page. Also, any ideas on how to let them edit their information? Thanks 
Basically, you ned to get the unique ID number of the member, and then use a MySQL statement to find that user.
You will need to do something like that.
Code: Select all
$sql = "SELECT * FROM table WHERE id='$id'";
$rs = mysql_query($sql) or die(mysql_error());
$get = mysql_fetch_assoc($rs);
$variable = $get['column_name_such_as_username'];
$anotherVariable = $get['another_column_name'];
echo"Username: $variable
<br />
Something else: $anotherVariable";