Can't Create New User Id!

I have no knowledge what so ever about PHP. I purchased a small program several weeks ago and they loaded it for me. But there are functions that are not working properly. I emailed them many times for help but they never responsed back. My problem is this... After a person registers, they receive an email with their login information and are directed to their new website, which is the same index page as mine only they are suppose to have an id number in back of it. Everything works except it's not creating the new id number and when they login in it says You have entered invalid account information! I don't know which script the error might be in.. signup...members or login... I check with my host and they said everything was running fine from there. In fact I have another program which uses login information and it works fine. I have included sign up and members script. Please see if there is any errors. Thanks

SIGNUP:

$page = "signup.php?id=$id";

$id = $_GET['id'];

//(id,first_name,last_name,user,pass,email,upgrade,ref)

if (isset($submit))
{
mysql_query("INSERT INTO members (first_name,last_name,user,pass,email,upgrade,ref) Values ('$first','$last','$user','$pass','$email','$upgrade','$ref_user')");

// Retrieve new id for member

$new_member_id = mysql_query("SELECT * FROM members WHERE 'user' = '$user'");
$new_member_id = mysql_fetch_object($new_member_id);

$new_id = $new_member_id->id;

$sponsor_ads_id = mysql_query("INSERT INTO sponsor_ads (id) Values ('$new_id')");

$featured_ads_id = mysql_query("INSERT INTO featured_ads (id) Values ('$new_id')");

// End of query

print " <blockquote><blockquote><blockquote>Thanks for signing up! We have sent your login details to your email address $email! <a href=\"login.php\">Click here to login now!</a> Thanks, Admin <a href=$domain>$domain</a></blockquote></blockquote></blockquote>";

// Send email code goes here

$title = "New $title Account";
$message = "Hi $first,\n\nThanks for signing up with $title $domain\nYour Username is: $user\nYour Password is: $pass\n\nThanks,\nAdmin\n$domain\n\n";

mail("$email", "$title", $message,
"From: webmaster@{$_SERVER['SERVER_NAME']}\r\n" .
"Reply-To: webmaster@{$_SERVER['SERVER_NAME']}\r\n" .
"X-Mailer: PHP/" . phpversion());

exit;
}

?>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title><? print $title;?> Members Signup Form</title>
<link rel="stylesheet" type="text/css" href="design.css" />

if (field2.value == '')
{
alert("Last Name can't be empty");
return false;
}

if (field3.value == '')
{
alert("Username can't be empty");
return false;
}

if (field4.value == '')
{
alert("Password can't be empty");
return false;
}

if (field5.value == '')
{
alert("Email Address can't be empty");
return false;
}

return true;
}
</script>

</head>

<body>
<form action="<? print $page;?>" method="POST" onSubmit="javascript:return validateLogin(first, last, user, pass, email);">

<div align="center">
<center>
<table border="0" width="405" height="411">
<tr>
<td width="405" height="22" bgcolor="#000080">
<? print $title;?>
</td>
</tr>
<tr>
<td width="405" height="354" valign="top"> Signup Form 
 
First Name 

<input type="text" class=texta name=first>

Last Name 

<input type="text" class=texta name=last>

Username

Password

Valid Email Address

<input type="submit" class=texta name="submit" value="Join Now!">
</form>
 
<center>
<a href="index.php">No Thanks! I'll Join later!
</a></center>

</body>

</html>

MEMBERS:
<?
session_start();

include("config.php");

if ($user == "")
{
print "<center>You have entered invalid account information! <a href=\"login.php\">Click here!</a></center>";
exit;
}

if ($pass == "")
{
print "<center>You have entered invalid account information! <a href=\"login.php\">Click here!</a></center>";
exit;
}

$member_info = mysql_query("SELECT * FROM members WHERE 'user' = '$user' AND 'pass' = '$pass'");
$member_info = mysql_fetch_object($member_info);

$db_user = $member_info->user;
$db_pass = $member_info->pass;
$id = $member_info->id;

if (($user == "$db_user" ¦¦ $pass == "$db_pass"))
{
session_register("user");
session_register("pass");

print $id;
?>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title><? print $title;?> Members Login</title>
<link rel="stylesheet" type="text/css" href="design.css" />
</head>

<body>
<div align="center">
<center>
<table border="0" width="405" height="311">
<tr>
<td width="405" height="22" bgcolor="#000080">

<? print $title;?>



</td>
</tr>
<tr>
<td width="405" height="254" valign="top"> <? print $title;?> Members Main Menu
 
<center>
 
Your very own <? print $title;?> website is located at: <a href="<? print $domain;?>/index.php?id=<? print $id;?>" target=_blank><? print $domain;?>/index.php?id=<? print $id;?></a>

<a href="profile.php?id=<? print $id;?>">Profile</a>
 
<a href="sponsor_ads.php?id=<? print $id;?>">Sponsor Ads</a>
 
<a href="featured_ads.php?id=<? print $id;?>">Feature Ads</a>
 
<a href="logout.php">Logout</a>
 
</center>

</td>
</tr>
<tr>
<td width="405" height="19" bgcolor="#000080">
All Rights
Reserved. 2006
</td>
</tr>
</table>
</center>
</div>

</body>

</html>

<?
}
else
{
print "<center>You have entered invalid account information! <a href=\"login.php\">Click here!</a></center>";
session_unregister("user");
session_unregister("pass");
session_unregister("id");
session_destroy();

Can't Create New User Id!

Need Help!

sungirl848

FalseDawn

sungirl848

whoisgregg

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week