I am in the process of developing an events website. I would like the users to be able to see which of their events they have added are most popular. What I’m not sure about is how to link my database with pikwik ( just for reference I’m using php). The event id is stored in the url so the address would look like this domain.com/events/38/
The only thing I can think of is to query the events database for the event id of all events by a user, build an array and do a sequence of queries to the pikik database. Which seems horribly inefficient. It would also mean that the query would have to search for “/38/” within the url rather than doing a simple numerical match.
If anyone has any suggestion please let me know
Thanks very much