Login

07-27-2009, 08:58 AM

[eluser]Ci beginner[/eluser]
[quote author="Colin Williams" date="1248684219"]You need to tell the DB class to not protect identifiers by supplying a third param of TRUE.

Code:
$this->db->where('UNION ALL "

        SELECT * FROM `blog` ORDER BY `id` DESC

        UNION ALL

        SELECT COUNT(*) FROM blog_comentarios, blog WHERE blog_comentarios.post_id = blog.id"', NULL, TRUE);

[/quote]

Oops, bad news... I've tried the code:

Code:
$this->db->select('blog_comentarios.post_id, blog.id');

  $this->db->from('blog_comentarios, blog');

$this->db->where('UNION ALL "

  SELECT * FROM `blog` ORDER BY `id` DESC

  UNION ALL

  SELECT COUNT(*) FROM blog_comentarios, blog WHERE blog_comentarios.post_id = blog.id"', NULL, TRUE);  

  $data['query'] = $this->db->get();

And same error here:

Quote:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALL " SELECT * FROM `blog` ORDER BY `id` DESC UNION ALL SELECT COUNT(*) FROM ' at line 3

SELECT `blog_comentarios`.`post_id`, `blog`.`id` FROM (`blog_comentarios`, `blog`) WHERE `UNION` ALL " SELECT * FROM `blog` ORDER BY `id` DESC UNION ALL SELECT COUNT(*) FROM blog_comentarios, blog WHERE blog_comentarios.post_id = blog.id"

What can I do? Thank you!