Welcome member. I am able to get data added to my db and when it gets to the welcome page I want it to welcome $firstname but it comes up blank. How can I fix my echo statement.
<?php
session_id();
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome</title>
</head>
<body>
<?php
/ Program: New_member.php
Desc: Displays the new member welcome page. Greets
member by name and gives a choice to enter
restricted section or go back to main page.
*/
if (@$_SESSION['auth'] != "yes")
@include('Connections/connect_to_mysql.php');
$result = mysql_query("SELECT firstname FROM Members WHERE id='{$_SESSION['id']}'");
$row = mysql_fetch_array($result);
echo "<html>
<head><title>New Member Welcome</title></head>
<body>
<h2 style='margin-top: .7in; text-align: center'>
Welcome, $firstName </h2>\n";
?>
<p>Your new Member accounts lets you enter the members only section
of our web site. You'll find special discounts, a profile of matches,
live advise for experts, and much more.</p>
<p>Your new Member ID and password were emailed to you. Store them
carefully for future use.</p>
<div style="text-align: center">
<p style="margin-top: .5in; font-weight: bold">
Glad you could join us!</p>
<form action="profile.php" method="post">
<input type="submit"
value="Enter the Members Only Section">
</form>
<form action="index.php" method="post">
<input type="submit" value="Go to Main Page">
</form>
</div>
</body>
</html>