table Sessions contains user, ip, starttime and endtime.
table Activity contains ip, _time, miscdata
I will select a timerange (working fine)
I will select a user from a pulldown (working fine)
The resulting table give me all their Sessions during that timeframe (working fine)
Here is the part I can't seem to get-
I need to iterate through each row of those results and find all the events in Activity where the ip matches, and the event falls between starttime and end time of that row.
Basically giving me all Activity for that User, during that timeframe so I can do statistics on them.
I can show the data for a specific session, just not all of them.
The session ip's are reused, which is why I have to initially pull a list of user sessions.
Ideas?
... View more