From: Hank
Date: January 24 2006 12:52am
Subject: Re: count(*) send a wrong value
List-Archive: http://lists.mysql.com/mysql/194161
Message-Id: <1990a96b0601231652x87f0186gf77ccd9c09578db5@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

My guess would that your PHP code is not written correctly.

For instance, if you have a query in PHP:

$sql=3D"select * from my_table where cid=3D123";

...and are using the PHP function mysql_numrows() to count the
results, and then for your next test... you're just changing the query
to:

$sql=3D"select count(*) from my_table where cid=3D123"

and still using the mysql_numrows()  to get the result, that is your
error.  You'll need to use mysql_result() or some other fetch function
to get the results of the query.

That's my guess.

-Hank