One field.

[ctahk0]

Hi, can you please show me how to select only one field from database? I'm little confused about where to put select query.. Here is my code (and won't work of course) :) thanks.

$grid = new Grid("tblitems", array(
    "save"=>true,
    "delete"=>true,
    "where"=>"codeID != ''",
    "select" => 'selectFunction'
));

// 'selectFunction'
function selectFunction($grid) {
    $selects = array();

    $grid->table = "tblitems";
    $selects["codeID"] = $grid->makeSelect("codeID");

    // active select
    $selects["active"] = array("1"=>"true","0"=>"false");

    // render data          
    $grid->render($selects);
}

[optikalefx]

You're thinking too hard about it. The HTML dictates the fields you select from the table.

<th col="oneField"></th>

That will select that field from your tblitems table. The "select" is for select boxes, in other words, a combo box.