Universal function for datatables

        /**
        * Query builder for getting most datatables
        *
        * @param string $table
        * @param array $where
        * @param string $distinct_field
        * @param string $order
        * @param string $limit
        * @internal param bool $distinct
        * @internal param null|string $field
        * @return array $roles_array with rows from database
        */
        function getDatatable($table, $where = array(), $distinct_field = null, $order = null, $limit = null){
            $where_sql = '';
            if(count($where) > 0)
            {
                foreach($where as $column => $value)
                {
                    $where_sql .= "`". datacheck($column) ."` = '". datacheck($value) ."' AND ";
                }
            }
            $where_sql .= " 1=1";

            $db = new db('default');
            if(!is_null($distinct_field))
                $select = "SELECT DISTINCT `".datacheck($distinct_field)."`";
            else
                $select = "SELECT * ";
            $sql = $select ."FROM `project_roles` WHERE ".$where_sql;
            if(!is_null($order))
                $sql .= "  ORDER BY `". datacheck($order) ."` ";
            if(!is_null($limit))
                $sql .= " LIMIT ".datacheck($limit);
            $datatable = $this->query($sql); //This function is actually in a bigger DB class. this just executes the query and returns results
            $rows_array = array();
            while($datatable = $row->fetchrow())
            {
                array_push($rows_array, $row);
            }
            return $rows_array;
        }