Create a MySQL SELECT string from checkbox array

[datona]

I am look for a method to create an SQL query string.
Example:

If the client clicks on the following form checkboxes:

[x] column1
[] column2
[x] column3
[x] column4
[] column5

Then I can produce an SQL statement like:

"SELECT column1, column3, column4 FROM table"

I would ask if this is possible BUT, it seems ANYTHING is possible with a creative mind.

Thanks everyone for help on this issue.

[kingbear]

Assume that the form is POSTed and that the checkbox names are column1, column2, and column3 (assume there's only 3 of them -- change this to whatever you need)

$toSelect = "";

for($i = 1; $i < 3; $i++) {
   if(isset($_POST["column$i"])) {
       $toSelect .= "column$i,";
    }
}

// remove the last comma
$toSelect = substr($toSelect, 0, (strlen($toSelect) - 1))

$query = "SELECT $toSelect FROM table";