PHP + autogenerate IN() list data in MySQL query
Posted on 2012-03-13
I have developed a query that I use to generate a report for multiple users. Ideally, it would be better to use PHP to upload these list of users, then have that list automatically added to an IN statement in a query.
Select fname, lname
Where myuser.id IN ('123', '234', '567') *This is the data I'd like to pull in from a CSV file
Order by lname
I've written the code to create the upload file and place the CSV contents into a temporary table. How do I get that table data into the IN() statement.