mscreashuns — Thu, 12 Jul 2007 02:11:36 +0000

Yeah, greg, you are correct. I misread the link originally posted.

greg — Wed, 11 Jul 2007 20:17:11 +0000

mscreashuns;221488 wrote: ......The link is correct, .......

wouldn't an id of some sort need to be assigned to the url data being sent by the link?

Username

would be

Username

so user=username
then

$userName = $_GET['user'];

so the variable $userName would be assigned to the value of "username"

I am asking becasue I dont know
And to use the direct method you suggested will save time if I ever need it in the future

mscreashuns — Wed, 11 Jul 2007 13:30:59 +0000

I assume you are using MySQL for your database needs.

The link is correct, and then the profile page would look something like this, with your own modifications depending on your columns and design-related changes:

<?
//insert mysql connect information
$userName = $_GET['username'];
//Stores the username that was transferred via the URL you provided for use later

$getUser = mysql_query("SELECT * FROM users WHERE username = '$userName'");
//Selects all rows with the specified username (there should always be no more than one)
$numUser = mysql_num_rows($getUser);
//This gets the number of rows that the previous variable has found (this is for testing on the next line
echo "<table>";
if($numUser) {
  while($row = mysql_fetch_array($getUser)) {
    echo "<tr><th>";
    echo $row['userName'];
    echo "</th></tr>";
    echo "<tr><td><b>Location: </b></td><td>";
    echo $row['userLocation'];
    echo "</td></tr>";
  }
echo "</table>";
}
else {
echo "That username does not exist.";
//Provides a page if a user tries to insert a wacky username that doesn't exist.

I don't advocate the use of tables at all, but this gives you some sample code for how to display user data depending on what your field (column) names are.