like "id","username","email"
i don't know if got users logging in and how you will mange profile viewing but this is the basic code i think of right of the bat like this.
- Code: Select all
$username = "head"; (depends on if you use session etcs.)
$getuser = mysql_query("SELECT username FROM users WHERE username='$username'");
$username2= mysql_result($link, 0);
$getemail = mysql_query("SELECT email FROM users WHERE username='$username'");
$email= mysql_result($link, 0);