Activation Link issue!

tobymac

If you go to http://www.harborcityrecords.com/hcrindienetwork/msd/join_form.php
and fill out the form, it sends the activation email but! when i click the activation link in the email there is a problem! I get this:

ACTIVATION RESULTS

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/renovati/public_html/hcrindienetwork/msd/activation.php on line 22

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/renovati/public_html/hcrindienetwork/msd/activation.php on line 23

Your account could not be activated!

Could you please help me out! What do i need to change?

bradgrafelman

You should always be checking to see if [man]mysql_query/man returns boolean FALSE (indicating an error has occurred) and, if so, either outputting or logging (as appropriate) debug info (such as the error returned by the MySQL server - see [man]mysql_error/man - and the SQL query string itself, as it was sent to MySQL).

tobymac

that sounds complicated! could you possibly give me something to copy and paste?

tobymac

okay so i changed some things and now there is only 1 error!
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/renovati/public_html/hcrindienetwork/msd/activation.php on line 22

[/code]<html>
<body>
<h2>ACTIVATION RESULTS</h2>
<?
/
Created By Adam Khoury @ www.flashbuilding.com
-----------------------June 19, 2008-----------------------
/
//Connect to the database through our include
include_once "connect_to_mysql.php";
// Get the member id from the URL variable
$id = $_REQUEST['id'];
$id = ereg_replace("[^0-9]", "", $id); // filter everything but numbers for security
if (!$id) {
echo "Missing Data to Run";
exit();
}
// Update the database field named 'email_activated' to 1
$sql = mysql_query("UPDATE members SET emailactivated='1' WHERE id='$id'");
// Check the database to see if all is right now
$sql_doublecheck = mysql_query("SELECT * FROM members WHERE id='$id' AND emailactivated='1'");
$doublecheck = mysql_num_rows($sql_doublecheck);
if($doublecheck == 0){
// Print message to the browser saying we could not activate them
print "<br /><br /><div align=\"center\"><h3><strong><font color=red>Your account could not be activated!</font></strong><h3><br /></div>";
} elseif ($doublecheck > 0) {
// Print a success message to the browser cuz all is good
// And supply the user with a link to your log in page, please alter that link line
print "<br /><br /><h3><font color=\"#0066CC\"><strong>Your account has been activated!<br /><br />
</strong></font><a href=\"http://www.somewebsite.com/login.php\">Click Here</a> to log in now.</h3>";
}
?>
</body>
</html>