Register and Login, mysql_result argument error

[TheChosenHalf]

Hi,

I'm having trouble with the Register an Login tutorial part 4(actualy the error is in user.inc.php), when I try to register with empty fields I get an error(I've been trying to solve it for an hour):

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

code:

function user_exists($user){
	$user = mysql_real_escape_string($user);
	
	$total = mysql_query("SELECT COUNT('user_id') FROM 'Accounts' WHERE 'user_name' = '{$user}'");
	
	return (mysql_result($total, 0) == '1') ? true : false;
}

Help would be appreciated.

[Temor]

You're using semi-quotes ( ' ) where you should be using backticks ( ` ).
This:

 $total = mysql_query("SELECT COUNT('user_id') FROM 'Accounts' WHERE 'user_name' = '{$user}'");

Should look like this:

 $total = mysql_query("SELECT COUNT(`user_id`) FROM `Accounts` WHERE `user_name` = '{$user}'");

For future reference, add

die(mysql_error());

or

echo mysql_error();

after the query that is failing and it will give you detailed instructions on what's causing the error.

[TheChosenHalf]

eh, still the same problem.

[Temor]

is the table named Accounts?

[EcazS]

Did you actually put echo mysql_error(); after your query?
It should have given you different error.

[bowersbros]

post your new code

[TheChosenHalf]

yes, the name is Accounts

the mysql_error() did nothing... :s

and here is the new code:

function user_exists($user){
	$user = mysql_real_escape_string($user);
	
	$total = mysql_query("SELECT COUNT(`user_id`) FROM `Accounts` WHERE `user_name` = '{$user}'");
	
	return (mysql_result($total, 0) == '1') ? true : false;
	echo mysql_error();
}

edit: You can check yourself: http://www.cevapinpol.comlu.com/
Go to testing area 1 and try to register with no info inputed... It doesnt register even if you enter info anyway because it uses the same function.

[bowersbros]

the reason it did nothing is because you did it too late.

Do it before the return.

[TheChosenHalf]

i tied that too...

oh... wait it did throw an error, wrong db name -.-"
thanks for the help