How to multiple sum mysql?

Question

I have a script that sums everything in te field "total" and its ok.

$cleaner = $connection->query("SELECT *,SUM(total) as total FROM ventas where fecha='$datenow'");

but I want to create more filters, when the caja is nails

$cleanerx = $connection->query("SELECT *,SUM(total) as total FROM ventas where fecha='$datenow' and caja='NAILS'");

why is not working, I read the tutorials at php but I don't understand why is not working.

Varun Malhotra · Accepted Answer · 2017-10-25 04:15:58Z

1

you can do it like this:

$cleaner = $connection->query("SELECT *,SUM(total) as total,(SELECT SUM(total) as total FROM ventas where fecha='$datenow' and caja='NAILS') as totalnails FROM ventas where fecha='$datenow'");

answered Oct 25, 2017 at 4:15

Varun Malhotra

1,2043 gold badges17 silver badges28 bronze badges

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

3 Comments

Alexander Spirinov Over a year ago

Thank you very much for your help!

Varun Malhotra Over a year ago

your welcome please accept the answer if its help full to you :)

Alexander Spirinov Over a year ago

Hi, sorry for the inconvenience, we have a problems but i have a caja named "NAILS/SALON" only filtered with the date and the caja ?

Collectives™ on Stack Overflow

How to multiple sum mysql?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related