Where clause in editor post action

mRender

I was wondering why I was getting invalid JSON from this because of my where clause.

if ( !isset($_POST['action']) ) {
    // Get a list of sites for the `select` list
    $data['tbl_Login'] = $db
        ->selectDistinct( 'tbl_Login', 'UID as value, email as label' )
        ->where('UID', 1)
        ->fetchAll();
}

Shouldn't I be able to have a where clause and only select the users with UID = 1?

allan

The selectDistinct method returns a Result - not a Query instance, so it doesn't have a where method.

You can pass in a third parameter to selectDistinct to act as a select (docs).

if ( !isset($_POST['action']) ) {
    // Get a list of sites for the <code>select</code> list
    $data['tbl_Login'] = $db
        ->selectDistinct( 'tbl_Login', 'UID as value, email as label', array( 'UID'=>1) )
        ->fetchAll();
}

Allan