How to Write an Active record Query for Count and Union

Question

I wrote a query to get count of entries in SQL table I was using active record in CodeIginitor

This code is not working ... saying error in query line

$this->db->query('SELECT COUNT(*) FROM site UNION SELECT COUNT(*) FROM userdata'); 
$result=$this->db->get();
return $result->result();

I searched to get a corresponding active record query but have not got any result

change query to this:- `$this->db->query('(SELECT COUNT(*) as count_site FROM site) UNION (SELECT COUNT(*) as count_userdata FROM userdata)');` — Alive to die - Anant, Nov 05 '18 at 07:39
What are you trying to achieve with this query? Do you need the number of rows in each table or the total rows? — Nigel Ren, Nov 05 '18 at 08:34
You need to give different alias names to `COUNT(*)` in your query, otherwise it will throw error So do like this:- `$this->db->query( '(SELECT COUNT(*) as count_site FROM site) UNION (SELECT COUNT(*) as count_userdata FROM userdata)' );` — Alive to die - Anant, Nov 12 '18 at 10:54

score -1 · Accepted Answer · edited Nov 13 '18 at 04:38

-1

 $this->db->query(
    '(SELECT COUNT(*) as count_site FROM site) 
    UNION 
    (SELECT COUNT(*) as count_userdata FROM userdata)'
 );
 return $query->result();

edited Nov 13 '18 at 04:38

Alive to die - Anant

70,531
10
51
98

answered Nov 05 '18 at 13:00

Abdul khalik

64
2

5

Your code snippet seems to be helpful, but you should explain what is wrong with the OPs code and how you fixed it. – Thomas Urban Nov 05 '18 at 16:18

How to Write an Active record Query for Count and Union

1 Answers1