You can do it all in one query, just as you're already doing it:
SELECT COUNT(*) AS count FROM stats GROUP BY ip
Kim Steinhaug wrote:
Hello,
Im about to write a script that will generate several reports from
a database which loggs all visits. I see that my script will need
alot of queries
Whoops, forgot the rest of the fields.
SELECT COUNT(*) AS count, * FROM stats GROUP BY ip
Note that this will not work on Oracle and some other DBs. It will work
in MySQL. Oracle will only let you do:
SELECT COUNT(*) count, ip, FROM stats GROUP BY ip
Justin Patrin wrote:
You can do it all in
Thanks for your ideas, im sitting here drinking beer and drinks, so
Im having a little difficulty grasping the whole idea with this new
SQl statement, but it works! Thanks a lot.
To help the other people reading this who might not get it I did
some benchmarking, my method (mentioned in the
