Problem with Email Validation/Account Activation Script

[shatteredroses]

I'm using the following script in this user management system I'm working on.
So far, I have it so the user can create an account, is sent an email with an encrypted password and asked to follow a link to activate.php which SHOULD update their account to activated and give them the ability to log in.
However, no matter what I do I always get 'Your account could not be activated . . .'
I've stared and stared at the code and I can't see any problems with it. Perhaps you guys will have better luck with it?

<?

// Get database connection
include 'db.php';

// Create variables from URL.

$userid = $_REQUEST['id'];
$code = $_REQUEST['code'];

$sql = mysql_query("UPDATE profiles SET activated='1' WHERE userid='$userid' AND password='$code'")or die(mysql_error()); 

$sql_doublecheck = mysql_query("SELECT * FROM profiles WHERE userid='$userid' AND password='$code' AND activated='1'")or die(mysql_error());
$doublecheck = mysql_num_rows($sql_doublecheck)or die(mysql_error());

if($doublecheck == 0){
	echo "Your account could not be activated, please contact [email][e-mail][/email];
} elseif ($doublecheck > 0) {
	echo "Your account has been activated. You may login below:<br />";
	include 'login_form.html';
}

?>

Thanks in advance for your help.
Roses

[shatteredroses]

Incidentally, the error I'm getting in my errorlog is as follows:

[02-Oct-2004 19:22:21] PHP Warning: Unknown(): Unable to load dynamic library './ixed.lin.4.3.9.pxp' - ./ixed.lin.4.3.9.pxp: cannot open shared object file: No such file or directory in Unknown on line 0

[shatteredroses]

I'm now having this same problem with another code block developed from the same tutorial.
I've managed to work out a lot of my code, but I'm still getting the following error whenever I try an execute it:

Unknown(): Unable to load dynamic library './ixed.lin.4.3.9.pxp' - ./ixed.lin.4.3.9.pxp: cannot open shared object file: No such file or directory in Unknown on line 0

I have no idea what this error means, or what it's refering to. I don't know what the file path ./ixed.lin.4.3.9.pxp is, or why it would want access to it.
If anyone knows why I'm getting this error, what it means, or even just how I can fix it then I'd be really greatful.
Thanks again.

[homer09001]

shatteredroses wrote:

I'm using the following script in this user management system I'm working on.
So far, I have it so the user can create an account, is sent an email with an encrypted password and asked to follow a link to activate.php which SHOULD update their account to activated and give them the ability to log in.
However, no matter what I do I always get 'Your account could not be activated . . .'
I've stared and stared at the code and I can't see any problems with it. Perhaps you guys will have better luck with it?

<?

// Get database connection
include 'db.php';

// Create variables from URL.

$userid = $_REQUEST['id'];
$code = $_REQUEST['code'];

$sql = mysql_query("UPDATE profiles SET activated='1' WHERE userid='$userid' AND password='$code'")or die(mysql_error()); 

$sql_doublecheck = mysql_query("SELECT * FROM profiles WHERE userid='$userid' AND password='$code' AND activated='1'")or die(mysql_error());
$doublecheck = mysql_num_rows($sql_doublecheck)or die(mysql_error());

if($doublecheck == 0){
	echo "Your account could not be activated, please contact [email][e-mail][/email];
} elseif ($doublecheck > 0) {
	echo "Your account has been activated. You may login below:<br />";
	include 'login_form.html';
}

?>

Thanks in advance for your help.
Roses

im only a php newb but youve missed you double quotation marks of the bottom line with your e-mail address on