Page 1 of 1

Query Possible?

Posted: Thu Jan 12, 2006 10:02 am
by AGISB
I got a list with ID and IP adresses and page names and timestamp.

Now I want to check if a certain ip went directly form lets say index.html to registration.html

Is this possible in one query?

Posted: Thu Jan 12, 2006 10:30 am
by Weirdan
Yep, but that would be very resource-intensive query. Instead, just select individual sessions like this:

Code: Select all

select distinct ip from logTable;
for each $ip from above query:
  select id, pagename, timestamp from logTable where ip=$ip order by timestamp asc
Then go through the result-set in a loop and check if there were transitions you're looking for.