I need to write select statement as we can passe columns in to query dynamically using PHP language.
I have a query like this.
SELECT `Pro_Csharp` + `Pro_Java` + `Pro_VBA` + `Pro_Cplus` + `Frameworks_Aspdotnet` + `Fram_MVCdotnet` + `Fram_WCF` + `Fram_Hibernate` + `Fram_Struts` + `Fram_Spring` + `Data_transformations_XML` + `Data_transformations_XSL` AS total_skill
FROM wp_skilllist
ORDER BY total_skill DESC
From the interface users can select which subject they want to select.There are about 130 columns. Therefore, I want to handel it dynamically. Is there way to do this?
If we can't do this with mysql and suggestion to this with php language also very helpful.