Warning: mysql_result() expects parameter 1

[davishs]

I get this error.

 

Warning: mysql_result() expects parameter 1 to be resource, boolean given in D:\++----LIETOTAAJI----++\Davis\Tikai MAN\Programmas\INSTALLED\wamp\www\New2\wpadmin\index.php on line 10

 

And I got this php code. I'm guessing I have some problems with quotes or smth.

 

<?php
#iekļauj konfigurāciju
include("../config.php");
if(isset($_POST['username']) and isset($_POST['password']))
{
$username = quote_smart($_POST['username']);
$password = quote_smart(md5($_POST['password']));

$result = mysql_query("SELECT COUNT (*) FROM `users` WHERE nickname = $username AND password = $password");
if(mysql_result($result,0,'COUNT(*)') > 0)
{
	echo "SELECT COUNT (*) FROM `users` WHERE nickname = $username AND password = $password";
}
}
?>

 

What is the problem, could you tell me, please?

[Pikachu2000]

The query is failing and mysql_query is returning boolean FALSE.

 

mysql_error should help give you an idea as to why that's happening.

[fenway]

It's happening because of the space between COUNT and (*).

[davishs]

Now I feel a little stupid.

Thanks mate. It helped.