I want to know how to select columns from mysql usng php. I know I can select columns in mysql using the following statement:
Select column1, column2 from table where company like '%abc%'
how do i do the same using php, is it going to be:
select '".$_GET['column']."' from table where comapny like '%".$_GET['abc']."%'
basically I have a survey table with 12 columns, I want users to only search and view columns they want e.g. user1 wants to view companies with higher market position, user2 wants to see brands, companies and display items, user3 wants to see companies with multi branches and their top selling brands.
Is it possible and can someone point me to the right direction.
Thanks in advance