[eluser]velti[/eluser]
Another example:
Code:
$this->db->select( $this->_table_data.'.ID,
'.$this->_table_data.'.title,
'.$this->_table_data.'.text,
DATE_FORMAT( '.$this->_table_data.".time, '%d-%m-%Y' ) AS time,
".$this->_table_data.'.groupID,
'.$this->_table_groups.'.title as grouptitle
');
results in:
Quote:Error Number: 1054
Unknown column ''%d-%m-%Y'' in 'field list'
SELECT `news_data`.`ID`, `news_data`.`title`, `news_data`.`text`, DATE_FORMAT( news_data.time, `'%d-%m-%Y'` ) AS time, `news_data`.`groupID`, `news_groups`.`title` as grouptitle FROM (`news_data`) INNER JOIN `news_groups` ON `news_groups`.`ID` = `news_data`.`groupID` ORDER BY `news_data`.`time` DESC LIMIT 8
Using FALSE as 2nd parameter it works as well as before updating. But i think it's not the meaning to use FALSE in every query now.