Hey,

I have created a test membership site and am having a little bit of difficulty. Check this link:

http://www.gallaghermail.com/phptest...join_form.html

You can login there and it will register the user okay to the mysql database. Originally, the "activation" was set to "null". For some reason, when the user gets the welcome email, they click the link but it does not change the activate membership on the mysql side. It remains null. So just for a test, I set the default to "1" which will activate the account.

If you could - try to register as a new user, then go and login. You should be able to get that far. From there, 3 newsletters should be available but check out the parse error on this location:
http://www.gallaghermail.com/phptest...newsletter.php

Not sure where it's hanging up..

2nd thing real quick

I have on http://www.gallaghermail.com/phptest/logon/

click on "signup.html" and it lets you create an account just fine. If you go to "login.html" it will let you login and gives the message just fine as well. The problem is when you don't enter your credentials correctly it just sits at a blank page. Here is the code:
__________
$username = $_POST["username"];
$password = $_POST["password"];

$result = MYSQL_QUERY("SELECT * from users WHERE username='$username'and password='$password'")
or die ("Name and password not found or not matched");

$worked = mysql_fetch_array($result);

$username = $worked[username];
$password = $worked[password];
$email = $worked[email];

if($worked)
echo "Welcome $user! Your e-mail address is $email";
?>

What do you think it's messing up on?