Welcome Guest, Not a member yet? Register   Sign In
JOIN query problem
#1

[eluser]vps4[/eluser]
I using SQLITE database

when I do this
Code:
$this->db->select('article.ID, article.node_ID, article.title, node.node_title');
            $this->db->from('article');
            $this->db->join('node', 'node.node_ID = article.ID');
            $this->db->limit(1);
            $query = $this->db->get();

it give me an error:

Code:
A Database Error Occurred
Error Number: 1

SQL logic error or missing database

SELECT article.ID, article.node_ID, article.title, node.node_title FROM (article) JOIN node ON node.node_ID = article.ID LIMIT 1

how can I fix it?
#2

[eluser]geocine[/eluser]
Try this:

Code:
$this->db->select('*');
            $this->db->from('article');
            $this->db->join('node', 'node.node_ID = article.ID');
            $this->db->limit(1);
            $query = $this->db->get();

and see what you get.




Theme © iAndrew 2016 - Forum software by © MyBB