form validation question

[eluser]rsmarsha[/eluser]
I moved the validation to a config file as suggested earlier in the post which as you said does make it tidier.

Code:

<?php
$config = array(
    'write_blog_post' => array(
        array(
            'field' => 'title',
            'rules' => 'required|xss_clean'
        ),
        array(
            'field' => 'content',
            'rules' => 'required|xss_clean'
        ),
        array(
            'field' => 'category',
            'rules' => 'is_natural_no_zero'
        )
    )                        
);

I made the changes you suggested though as this is an admin form I just have the submitted message show on the write page in case the user wants to write another post.

So : -

Code:

public function write () {
        if ($this->form_validation->run('write_blog_post') === FALSE)
        {
            $data = array(
                'categories' => $this->blog_model->get_categories(),
                'message' => (validation_errors()) ? validation_errors() : $this->session->flashdata('message')
            );
            $this->_view('admin/blog_write_post', $data);
        }
        else
        {
            $result = $this->blog_model->insert_post();
            if ($result){
                $this->session->set_flashdata('message', 'Blog Entry Submitted');        
            }
            else
                {
                $this->session->set_flashdata('message', 'An Error Occured Submitting the Post');
                
            }
            redirect('admin/blog/write');
        }
    }

I tried the order_by method you suggested and I get the same error. I've checked the fields and can't work it out, it's as if the order by breaks the query.