Define fields to be returned with PDO variables

[Adamhumbug]

Hi all,

I have a function that is returning data from a select statement.

I am wanting to change the fields that are returned dynamically based on a variable that is passed into the function.

I thought i would be able to do this with a switch and a variable name in the select statement.

I have done some reading and it seems that this is not a thing that can be done.

Would the best option be to get all fields that i might want to decide which to use after the data has been returned?

 

[mac_gyver]

of course you can do this, by supplying an array of the column names as an input to the function, then dynamically building the select list (see php's implode() function).