Reply to thread

Message: <blockquote data-quote="ArunaTelshan" data-source="post: 23444600" data-attributes="member: 495249">man gawa table dekak thiyenawa mata meken report ekak desigh karaganna one. katahari puluwanda meka hadaganna widiyak kiyanna. man haduwa widiyata empty columns godak enawa. aurudu deka thunaka report ekak gannath ba monthly group kaloth <img src="/styles/default/xenforo/smilies/default/sad.gif"  class="smilie" loading="lazy" alt=":(" title="Sad    :(" data-shortname=":(" /><img src="/styles/default/xenforo/smilies/default/sad.gif"  class="smilie" loading="lazy" alt=":(" title="Sad    :(" data-shortname=":(" /><img src="/styles/default/xenforo/smilies/default/sad.gif"  class="smilie" loading="lazy" alt=":(" title="Sad    :(" data-shortname=":(" /><img src="https://i.imgur.com/TT1cC4K.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" /><img src="https://i.imgur.com/an6i2ai.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />me wage ekak hadagannai one.<img src="https://i.imgur.com/iM6k95a.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />me mage query eka[PHP]SELECT    student.stu_name,    SUM(IF(MONTH(fees.date) = 1, fees.amt, 0)) AS Jan,    SUM(IF(MONTH(fees.date) = 2, fees.amt, 0)) AS Feb,    SUM(IF(MONTH(fees.date) = 3, fees.amt, 0)) AS Mar,    SUM(IF(MONTH(fees.date) = 4, fees.amt, 0)) AS Apr,    SUM(IF(MONTH(fees.date) = 5, fees.amt, 0)) AS May,    SUM(IF(MONTH(fees.date) = 6, fees.amt, 0)) AS Jun,    SUM(IF(MONTH(fees.date) = 7, fees.amt, 0)) AS Jul,    SUM(IF(MONTH(fees.date) = 8, fees.amt, 0)) AS Aug,    SUM(IF(MONTH(fees.date) = 9, fees.amt, 0)) AS Sep,    SUM(IF(MONTH(fees.date) = 10, fees.amt, 0)) AS Oct,    SUM(IF(MONTH(fees.date) = 11, fees.amt, 0)) AS Nov,    SUM(IF(MONTH(fees.date) = 12, fees.amt, 0)) AS Dece,    SUM(fees.amt) AS Total,    (28000-(SUM(fees.amt))) AS BalanceFROM    feesINNER JOIN student ON fees.stu_id = student.idGROUP BY student.stu_idWITH ROLLUP[/PHP]</blockquote>

Verification: Payakata winadi keeyak tibeda?

Top Bottom