CodeIgniter Forums
Problem with select method (DB Class) - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Problem with select method (DB Class) (/showthread.php?tid=34223)



Problem with select method (DB Class) - El Forum - 09-23-2010

[eluser]Unknown[/eluser]
Hello Guys, im new at coding with CodeIgnitor.

Now i've got an silly problem...

Code:
$this->db->select('meta_charset', 'meta_title', 'meta_keywords', 'meta_description');

$q = $this->db->get('core_settings');

$data = $q->result();

Last Query will show only
Quote:SELECT `meta_charset` FROM (`core_settings`)

Why does the select methods only recordnize the first string (meta_charset)?


Problem with select method (DB Class) - El Forum - 09-23-2010

[eluser]Unknown[/eluser]
solution:

change this:
Code:
$this->db->select('meta_charset', 'meta_title', 'meta_keywords', 'meta_description');

to this:
Code:
$this->db->select('meta_charset, meta_title, meta_keywords, meta_description');

now it works

@thanks to: wiredesignz_ and Titosemi @ chat


Problem with select method (DB Class) - El Forum - 09-23-2010

[eluser]wiredesignz[/eluser]
Or you could try.
Code:
$this->db->select('meta_charset');
$this->db->select('meta_title');
$this->db->select('meta_keywords');
$this->db->select('meta_description');