[SOLVED] Strange Errors I Can't Get Rid Of..

[monkeypaw201]

I posted the code below, i personally can't find anything wrong with it and have triple-checked spelling and the form names etc...

 

$user = mysql_query("SELECT * FROM `users` WHERE `activation_key` = '$_POST[key]' AND `email` = '$_POST[email]'");
$row_user = mysql_fetch_array($user);
$user_count = mysql_num_rows($user);

 

the errors:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in public_html/human-resources/confirm.php on line 45

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in public_html/human-resources/confirm.php on line 46

[genericnumber1]

the real problem is with the query, try changing the first line to

 

$user = mysql_query("SELECT * FROM `users` WHERE `activation_key` = '$_POST[key]' AND `email` = '$_POST[email]'") or die(mysql_error());

 

that should tell you what is wrong with your query (I haven't looked to see if I see anything wrong)

[MasterACE14]

the query should be like this....

 

$user = mysql_query("SELECT * FROM `users` WHERE `activation_key` = '" . $_POST['key'] . "' AND `email` = '" . $_POST['email'] . "'") or die(mysql_error());

 

You just needed to insert the $_POST's correctly.

 

Regards ACE