When COUNT counts wrong

[sinbadly]

When I ask the table for this precise number of rows ...

$result2 = @mysql_query("SELECT COUNT(*)AS t FROM 067staff WHERE  m = '10' ");

... it doesn't. I'm using it for pagination on the website, but it shows every page as the last page.

Is there a way to make the code behave, please?

 

[feherke]

Hi

I do not believe this can be a MySQL issue.

There you are suppressing the error messages with the at ( @ ). In such cases put something like this after that :

if (!$result2) die('Invalid query: '.mysql_error());

Please confirm that the following gives incorrect result :

$row=mysql_fetch_assoc($result2);
echo $row['t'];

Otherwise you will have to repost this question in forum434 ( PHP ).

Feherke.

http://rootshell.be/~feherke/

 

[sinbadly]

Yes, I am in the wrong section. Sorry, Feherke.