$this->db->select()

[eluser]Ajaxboy[/eluser]
$this->db->select() doesn't work with from_unixtime (and possibly others mysql functions) , this is my query..

$cl = get_instance();
$cl->load->database();
$cl->db->select("id,subject,priority, from_unixtime(`created`,'%M %D, %l:%i %p')");

it generates this for the "created" field:

from_unixtime(`created`, `'%M` %D, `%l:%i` %p')

note that it adds different ```` where is not needed, and throws an error..


just reporting this as a bug..

[eluser]Developer13[/eluser]
Check the documentation. It's not a bug.

[eluser]Ajaxboy[/eluser]
I've read the documentation http://ellislab.com/codeigniter/user-gui...ecord.html

How is it not a bug?

[eluser]Developer13[/eluser]
I'm not going to do your thinking for you. Hint: backticks.

[eluser]Ajaxboy[/eluser]
that makes sense lol, my mad. Just didn't understand the statemented as referenced in the docs