$this->db->select("FROM_UNIXTIME( LOGTIME, '%D %M %Y') AS date");
And how to fix it, is by adding FALSE on db select like example below:
$this->db->select("FROM_UNIXTIME( LOGTIME, '%D %M %Y') AS date", FALSE);
Monday, June 20, 2011
Codeigniter: SQL Select query FROM_UNIXTIME
I keep having error when I made this sql select:
And how to fix it, is by adding FALSE on db select like example below:
And how to fix it, is by adding FALSE on db select like example below:
Subscribe to:
Post Comments (Atom)
Hi am using below line in my query
ReplyDelete$this->db->group_by('FROM_UNIXTIME(E.servertime,"%Y-%m-%d")', FALSE);
but when i execute its appending FROM_UNIXTIME(E.servertime, `"%Y-%m-%d")` how to resolve this please help me
$this->db->select() accepts an optional second parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks. This is useful if you need a compound select statement.
Delete$this->db->select() accepts an optional second parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks. This is useful if you need a compound select statement.
ReplyDelete