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?
Query Possible?
Moderator: General Moderators
Yep, but that would be very resource-intensive query. Instead, just select individual sessions like this:
Then go through the result-set in a loop and check if there were transitions you're looking for.
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