Additional query without the need of using a loop.

ahwiewo · Anmeldedatum: 23.11.2011 Beiträge: 2

I have got a MySQL result in which all entries of a certain period of time are held. These entries are login data and its corresponding members. The quantity of that entries can be up to 50000 depending on the chosen period of time.
The data come from 2 tables and I used a LEFT JOIN to get that result.

Now using that result of all entries lets assume the number is 250 I need to get the number of logins of each member which are held in the second table. In other words - I need to find out how often each member has logged in within that period of time?
There is only the chance to use a loop to get the result as far as my limited knowledge of MySQL is.
I would rather do without using a loop if there is a chance to do so.

How could that be done?

hgfelix · Anmeldedatum: 31.03.2012 Beiträge: 4

there are always several ways to reach rome Very Happy

If you might post the two table's structure (partially) and the expected result I can propably help you.

Regards