[SOLVED] Registration to Profile Page

[Joshv1288]

I Was Wondering how i can get my registration page to make the profile page after a user submits there information

[DarkWater]

Well, you assign a unique ID to each user, correct?  Just pass it in the url to like, profile.php (i.e: profile.php?id=3) and then use $_GET['id'] to form a query.

[trq]

You might find this helpfull.

[Joshv1288]

im using that code and i get this error

 

Parse error: syntax error, unexpected T_ELSE in /home/h3swat/public_html/index.php on line 42

 

 } else {
    echo "Query failed ". mysql_error();
  }

[trq]

There is a missing } just prior to the } else { in that code. It was untested (obviously).

[Joshv1288]

its there hers the whole code updated for my database

 

   $sql = "SELECT username FROM users";
  $result = mysql_query($sql);
  if ($result) {
    if (mysql_num_rows($result) > 0) {
      // here we loop through each member in the database
      while ($row = mysql_fetch_assoc($result)) {
        /// creating a link out of there uname, and passing there uname through the url.
        echo "<a href=\"profiles.php?member={$row['username']}\">{$row['username']}</a><br />";
      }
    } else {
      echo "No users found";
}
    else {

  echo "Query failed ".mysql_error();
    }
?>

[trq]

It still missing...

 

$sql = "SELECT username FROM users";
$result = mysql_query($sql);
if ($result) {
  if (mysql_num_rows($result) > 0) {
    // here we loop through each member in the database
    while ($row = mysql_fetch_assoc($result)) {
      /// creating a link out of there uname, and passing there uname through the url.
      echo "<a href=\"profiles.php?member={$row['username']}\">{$row['username']}</a><br />";
    }
  } else {
    echo "No users found";
  }
} else {
  echo "Query failed ".mysql_error();
}

?>

 

Consistent indentation is key to finding these errors.