i create a dropdown list for selecting a particular column value from a table. But if i select all in the dropdown list , it should get all the data which which select all the possible values of that column from the table. How to do it??
ex.
Consider i have a dropdown of country and if i select all then dynamically the query should be like, it will select all possible values of country from table.
You’ll need to check how many entries are in the array that comes in from the dropdown list, implode them using a comma as a separator, then build that into your query as the parameters for your “IN” qualifier. That would work for one or more selections, I think.