StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP MYSQL Query to combine and add two equalent result
text
Body
copied!<p>Somebody please help me to solve my sql query i have already spend two days for this....</p> <p>i have a MYSQL query given below </p> <pre><code>(SELECT c.cl_list as cl_list, c.name as name, pc.value as value, count( pc.value) as total FROM projs p LEFT JOIN classify_proj_new pc ON p.proj_id = pc.proj_id_fk LEFT JOIN classify_list c ON c.cl_list = pc.class_id_fk WHERE MATCH ( p.title ) AGAINST ( 'jerm' IN BOOLEAN MODE ) GROUP BY c.cl_list, pc.value) UNION ALL (SELECT c.cl_list as cl_list, c.name as name, pc.value as value, count( pc.value) as total FROM jerm p LEFT JOIN classify_jerm_new pc ON p.jerm_id = pc.jerm_id_fk LEFT JOIN classify_list c ON c.cl_list = pc.class_id_fk WHERE MATCH ( p.jermname ) AGAINST ( 'jerm' IN BOOLEAN MODE ) GROUP BY c.cl_list, pc.value) </code></pre> <p>Which Gives a result of (below):</p> <pre><code> cl_list name value total ------------------------------------------------------------------------------------ 1 department jewller 2 3 price 50 2 6 color blue 1 6 color Red 2 1 department jewller 1 6 color Red 1 </code></pre> <p>but i am trying to get a result which can add the repeating value's total and avoid repeating value....some thing like this (below):</p> <pre><code> cl_list name value total ------------------------------------------------------------------------------------ 1 department jewller 3 3 price 50 2 6 color blue 1 6 color Red 3 </code></pre> <p>somebody please help me i am very sad about my output...</p> <p>Thank you very much in advance...</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload