PHP Pagination problem, need some help !

[purebrand]

I have a problem counting the row's in the table.

$pages_query = mysql_query("SELECT COUNT(`id`) FROM nameslist WHERE abc = `a` ");

I get this error:
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\EasyPHP 3.0\www\website\names\index.php on line 107

The mysql query works without the " WHERE abc = `a` "
I really need to count just the lines where the collumn " abc " is set to " a ".

[purebrand]

I resolved the problem.
You can close this thread.