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:
[syntax=php]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;
}[/syntax]

Help would be appreciated.

[Temor]

You're using semi-quotes ( ' ) where you should be using backticks ( ` ).
This:
[syntax=php] $total = mysql_query("SELECT COUNT('user_id') FROM 'Accounts' WHERE 'user_name' = '{$user}'");[/syntax]
Should look like this:
[syntax=php] $total = mysql_query("SELECT COUNT(`user_id`) FROM `Accounts` WHERE `user_name` = '{$user}'");[/syntax]

For future reference, add [syntax=php]die(mysql_error());[/syntax] or [syntax=php]echo mysql_error();[/syntax] 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:
[syntax=php]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();
}[/syntax]


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