Welcome Guest, Not a member yet? Register   Sign In
Database Update not work
#1

[eluser]iniweb[/eluser]
I have this function on Newsmodel:

Code:
function Active_News()
    {
        $this->status      = $_GET['status'];

        $this->db->update('ci_news', $this, array('id', $_GET['id']));

        redirect('/index.php?c=Backoffice&m=News_List', 'refresh');
    }

Status = 1, but not updated.

This news table:

Code:
CREATE TABLE `ci_news` (
  `id` int(11) NOT NULL auto_increment,
  `author` varchar(30) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `alt_name` varchar(255) NOT NULL default '',
  `date` datetime default NULL,
  `category` smallint(5) unsigned NOT NULL default '0',
  `short_story` text,
  `full_story` text,
  `images` varchar(255) NOT NULL default '',
  `news_read` bigint(20) unsigned NOT NULL default '0',
  `allow_main` tinyint(1) NOT NULL default '0',
  `fixed` tinyint(1) NOT NULL default '0',
  `rating` smallint(5) NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  `_parent_name` varchar(255) default NULL,
  `_ci_scaffolding` varchar(255) default NULL,
  `_ci_scaff_table` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;
#2

[eluser]iniweb[/eluser]
$this->db->update('ci_news', $this, "id = $this->id");

This work Smile




Theme © iAndrew 2016 - Forum software by © MyBB