Warning: mysql_result(): supplied argument is not a valid MySQL result resource

[MrXortex]

G'day.

 

I got this error when I try to register a user. The function will basically check if the user already exist in the database or not.

 

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /hermes/web05/blubbz/functions/user.func.php on line 21

 

CODE:

 

<?php
function logged_in() {

}

function login_check($email, $password) {

}

function user_data() {

}

function user_register ($email, $name, $password) {

}

function user_exists ($email) {
$email = mysql_real_escape_string($email);
$query = mysql_query("SELECT COUNT('user_id') FROM 'users' WHERE 'email' = '$email'");
return (mysql_result($query, 0) == 1) ? true : false;

}
?>

 

Line 21 is:

 

return (mysql_result($query, 0) == 1) ? true : false;

[Barand]

After the query, echo mysql_error()

 

My guess is it's the quotes around your table name.

[MrXortex]

I tried changing the quotes, but I got the same error. Any other help please?

[Barand]

What did mysql_error() output?

[MrXortex]

Where do I put that mysql_output?

 

Give the whole code please?

[Barand]

After the query, echo mysql_error()

 

[mrMarcus]

I tried changing the quotes, but I got the same error. Any other help please?

 

To what?

 

$query = mysql_query("SELECT COUNT('user_id') FROM 'users' WHERE 'email' = '$email'");

 

Should be:

 

$query = mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `email` = '$email'");

[MrXortex]

Okay, I got this error now

 

Parse error: syntax error, unexpected T_RETURN, expecting ',' or ';' in user.func.php on line 22.

 

Line 22:

return (mysql_result($query, 0) == 1) ? true : false;

[mrMarcus]

Post your updated version of that function please.

[MrXortex]

Thanks a lot guys, its working now. All I had to do is replace those quotes, I misplaced them. Thanks!