We are running MySql version 5.0.45-Debian_1ubuntu3.1-log Debian etch
distribution under Ubuntu.
If I submit the following query via mysql_query it acts as if the where is not
there:
select count(*) as 'Count' from logins where player = 'aqwert';
this returns:
Count
143578160
Submitting the same query at a MySql prompt works correcty:
mysql> select count(*) as 'Count' from logins where player = 'dawiz';
+-------+
| Count |
+-------+
| 6026 |
+-------+
1 row in set (0.00 sec)
Modifying the query to use a group by returns the correct count:
Total Count
Total 6026
Is there something I should know about mysql_query and a simple count(*)?
G Vaughn
