Warning: mysql_affected_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\
Code (php)
1
2
3
4
5
6
7
2
3
4
5
6
7
$hash = $_GET['hash'];
$encrypted_email = urldecode($_GET['email']);
$query = "UPDATE user SET is_activated='1' WHERE confirm_hash = '$hash' AND email_adress = '$encrypred_email'";
$query_result = mysql_query($query);
if($query_result && mysql_affected_rows($query_result) == 1)
$encrypted_email = urldecode($_GET['email']);
$query = "UPDATE user SET is_activated='1' WHERE confirm_hash = '$hash' AND email_adress = '$encrypred_email'";
$query_result = mysql_query($query);
if($query_result && mysql_affected_rows($query_result) == 1)
De fout staat bovenin...
Ik zou niet weten wat ik ermee moest!
En als resource, word een mysql connectie bedoelt.
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?
$resource = mysql_connect('etc.....');
//DAN je query blablabal;
mysql_query('query lalala',$resource);
//en dan
mysql_effected_rows($resource);
?>
$resource = mysql_connect('etc.....');
//DAN je query blablabal;
mysql_query('query lalala',$resource);
//en dan
mysql_effected_rows($resource);
?>
Iets tussen de haakjes zetten, is eigenlijk alleen van toepassing, wanneer je er verschillende MySQL verbindingen op na houd.