06-13-2012, 03:45 AM
|
#2 (permalink)
|
|
The Acquainted
Join Date: Nov 2009
Location: nr Stratford-Upon-Avon
Posts: 137
Thanks: 3
|
You need to be handling errors to get to the bottom of your problem...
PHP Code:
$sql = mysql_query("UPDATE members SET email_activated='1' WHERE id='$id' AND password='$hashpass'");
$sql_doublecheck = mysql_query("SELECT * FROM members WHERE id='$id' AND password='$hashpass' AND email_activated='1'");
$doublecheck = mysql_num_rows($sql_doublecheck);
PHP Code:
$sql = mysql_query("UPDATE members SET email_activated='1' WHERE id='$id' AND password='$hashpass'");
if (!$sql){
echo "Error with update query : " . mysql_error();
}
$sql_doublecheck = mysql_query("SELECT * FROM members WHERE id='$id' AND password='$hashpass' AND email_activated='1'");
if (!$sql_doublecheck){
echo "Error in double check : " . mysql_error();
}else{
$doublecheck = mysql_num_rows($sql_doublecheck);
}
__________________
Thanks... Simon
Sex, Drugs & Linux Rules
|
|
|