Putting a session variable into a recordset
I've achieved two tables talking to each other before but struggling to make this situation work: Two database tables, one imported weekly with 50K records and one I've created to relate to it. I can create a details page I want manually but not dynamically. To do so I need to add a "LIKE" session variable into the WHERE clause of a recordset. EG:
"WHERE table1.field1 LIKE '%exampleText1%' AND table2.fieldB $_SESSION['exampleTextB']
I'd add a numeric field to the larger imported table that relates to mine but I would need to manually do this 50K times. Or, look to write some php to get the table as I need it but being able to use it as it comes will help as I'm importing such a large table so often.
Question is, is there another way to do this or can I have an example of how to add the session code into the recordset.