Newbie with MySQL. I have a user auth form before this
script which asks for username and password. First
Name and Last name are also in each record in the
database along with username and password. When
the user successfully logs in, I have it say, "Welcome
name_first, you're authorized! The only way I could figure
out how to do this is make a separate sql call to retrieve
the first name. Can I consolidate this into one call? Thanks.
(Based on "PHP Fast and Easy" code.)
<?
if ((!$username) || (!$password)) {
header("Location: blah");
exit;
}
$db_name = "notgonnadoit";
$table_name = "guess";
$connection = @mysql_connect("blah", "bleck", "bleep")
or die("Couldn't connect.");
$db = mysql_select_db($db_name, $connection)
or die("Couldn't select database.");
$sql = "SELECT * FROM $table_name
WHERE username = \"$username\"
AND password = password(\"$password\")
";
$result = mysql_query($sql)
or die ("Can't execute query.");
$num = mysql_numrows($result);
if ($num != 0) {
$connection = @mysql_connect("blah", "bleck", "bleep")
or die("Couldn't connect.");
$db = mysql_select_db($db_name, $connection)
or die("Couldn't select database.");
$sql1 = "SELECT username, name_first
FROM $table_name
";
$result1 = @mysql_query($sql1,$connection)
or die("Couldn't execute query.");
while ($row = mysql_fetch_array($result1)) {
$name_first = $row['name_first'];
$username1 = $row['username'];
if ($username1 == $username) {
$name_first1 = $name_first;
}
}
$msg = "<p>Welcome $name_first1, you're authorized!</p>";
} else {
header("Location: http://www.webdesigns1.f2s.com/db/auth_login.html");
exit;
}
?>
<html>
<head>
<title>Welcome</title>
</head>
<body bgcolor="#000000" text="#00ff00">
<? echo "$msg"; ?>
</body>
</html>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
