Optmization of select statement. HOW?

[grabiel]

 Hi
    I am using php/mapscript to generate the map. Also i am using ogr to connect to MySql table and displaying the result. As my MySql table is very large, it shows all the data (if i use *) or depending on my select statement(if i use field name in sql statement).
Both of these has some forms of limitations. 
        Can anyone please tell me how to run generic sql statement so that a user can choose the field name for query (say, population, male, female)before sending the request to the browser and depending on that mapserver should run the query? 
	
Any suggestion/experience will highly appreciated.
Thanks in advance
Grabiel 
 	
    
   




_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way  your home on the Web - http://www.myway.com