As a user is browsing our database, I want to be recording their history in a session.
I've got this aspect up and running in PHP.
But I'd like to be able to generate a a table of the full details of their browse history.
All I store in the session is the company ID, but if a user's been browsing the database all day there can be 300 or so items in the session.
I guess I could do the following query to return the full records...
Code: Select all
SELECT * FROM companies WHERE company_id=$company_id_0 OR company_id=$company_id_1 ... OR company_id=$company_id_480Or far better use the IN statement...
Code: Select all
SELECT * FROM companies WHERE company_id IN (1,2,3,4,5...890,898)But I was wondering if that's the best way to do what I'm looking for?
Is it appropriate to do this for thousands of values?
Or is there a better way I've not come across yet?
Or is the answer to just not do this type of thing?
Thanks in advance
Ben