Table with variable columns

[eluser]bradym[/eluser]
Building from sholnay's example, something like this should work:

Code:

$sql = "SELECT ";

$fields_selected = array('category' => 'selected category', 'style' => 'selected style');

$sql .= implode(',',array_keys($fields_selected));
$sql .= " FROM devices WHERE ";

foreach($fields_selected as $field => $value)
{
   $sql .= $field .' = '. $this->db->escape($value);
}

$this->db->query($sql);

Of course $fields_selected would be the checkbox values the user selected.