Counting rows from different tables in same query

Question

I thought i did something like this before:

$reg = mysql_query ("(SELECT count(*) from vouchers) as total_vouchers), 
                     (SELECT count(*) from vouchers WHERE asignado = 1) as vouchers_asignados,
                     (SELECT count(*) from crm) as crm_users,
                     (SELECT count(*) from datos_modificados) as dm_users") or die(mysql_error());

But it would return mysql_error near the first , :

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 'as total_vouchers), ((SELECT count(*) from vouchers WHERE asignado = 1) a' at line 1

Any idea why?

Robert · Accepted Answer · 2013-07-24 11:34:54Z

3

Try to add select as below

$reg = mysql_query ("SELECT
                     (SELECT count(*) from vouchers) as total_vouchers, 
                     (SELECT count(*) from vouchers WHERE asignado = 1) as vouchers_asignados,
                     (SELECT count(*) from crm) as crm_users,
                     (SELECT count(*) from datos_modificados) as dm_users") or die(mysql_error());

answered Jul 24, 2013 at 11:34

Robert

25.8k8 gold badges70 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Counting rows from different tables in same query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related