The Database Forum

**user465** · 11-16-2005, 03:30 PM

hello
i look for codes to show:

Viewing profile "userx" as title of the personal profilesite
where you see the information about userx

thx if someone can help

**Orodreth** · 11-16-2005, 03:51 PM

From a MySQL database? With PHP? With those 2 you could do it like this:

PHP Code:


			
<html>
<head>
<title><?php

$dbHost="your host";
$dbUser="your username";
$dbPass="your password";
$dbName="your database";
$dbTable="the table you want to use";
$dbField="the field you want to show in the title";
$dbWhereField="the field which the database has to check to find the right user";
$dbWhereValue="the value the \$dbWhereField has to have. Probably a $_GET[] value";

$db=mysql_connect($dbHost, $dbUser, $dbPass);
mysql_select_db($dbName, $db);

$user=mysql_fetch_row(mysql_query("SELECT `$dbField` FROM `$dbTable` WHERE `$dbWhereField`=`$dbWhereValue`;"));
echo "Your are viewing the profile of $user[0]";

?></title>
</head>
<body>
<!-- content of your page -->
</body>
</html>

**user465** · 11-16-2005, 04:20 PM

hi
what do u mean with
the field you want to show in the title

and how do i find out $dbWhereField

**Orodreth** · 11-16-2005, 06:14 PM

Well, with "the field you want to show in the title", I mean the field in the database where the user's name is in, which will be shown in the title.

"how do i find out $dbWhereField": $dbWhereField is a variable in the script above. $dbWhereField is used to find the username of the user you want to show in the page's title. The $dbWhereValue variable contains the value it has to have, so the query will find the username you need, and not usernames. The query will only return the username of the user for which the following statement is valid: $dbWhereField = $dbWhereValue.