PDA

View Full Version : Count hands in DB?



Gabethebabe
10-17-2008, 04:19 AM
Is there a way to count the number of hands I have stored in my database?
If it is, is it also possible to count the number of hands per stakes?

Thanks.

e306
10-17-2008, 04:29 AM
http://208.109.95.123/faq/afmviewfaq.aspx?faqid=19

Gabethebabe
10-17-2008, 02:03 PM
Kewl! Now how can I count just the NL100 hands, for example?

e306
10-17-2008, 04:11 PM
you have to play around with the SQL-query.
if you know sql: do the same query, group by gametype and left join with "gametypes".

if you downt know how sql works, tell me and i'll look at the query tomorrow.

Gabethebabe
10-18-2008, 01:42 AM
you have to play around with the SQL-query.
if you know sql: do the same query, group by gametype and left join with "gametypes".

if you downt know how sql works, tell me and i'll look at the query tomorrow.

I know some basic SQL, but at the moment we start with LEFT JOIN I´m afraid it´s out of my knowledge.

Im´interested in couting based on stakes and if possible on month, to know how much I´ve datamined in a month

e306
10-18-2008, 10:39 AM
ok, that does it:


SELECT gametypes.gametypedescription,count(*) FROM pokerhands LEFT JOIN gametypes ON pokerhands.gametype_id = gametypes.gametype_id GROUP BY gametypes.gametypedescription