Exporting current query results to CSV

[eluser]NeoArc[/eluser]
You should learn some MySQL

$query = $this->db->query(“SELECT id, name, date, telephone FROM users
WHERE creation_date < '2010-11-10' AND status=1 ORDER BY id DESC LIMIT 20”);