Updating config/routes.php using mysql

[eluser]robert.fulcher[/eluser]
I think the write_file will replace the contents and append. so try it like this...

Code:

function update_routes()
    {
            $this->db->select("*");
            $query = $this->db->get("articles");
            foreach ($query->result() as $r)
                {
                    $data = $data.'$route["' . $r['link'] . '"] = "' . $r['route'] . '";';
                }
            write_file(APPPATH . 'cache/routes.php', $data);                
    }

You might need to put a newline character in-between $data & $route.

Hope this helps.