Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
Ad icon
Wechat qr verification
Pawan2005
Updated:
Today at 1:28 AM
🚀 GOOGLE AI PRO 18 MONTHS ACTIVATION 🚀
sayuru bandara
Updated:
Yesterday at 5:34 PM
Pure VPN - Up to 27 Months
vgp
Updated:
Friday at 8:10 AM
එක පැකේජ් එකයි මාසෙටම Unlimited Internet. තාමත් DATA CARD දාන්න සල්ලි වියදම් කරනවද? අඩුම මිලට අපෙන්.
sayuru bandara
Updated:
Jun 2, 2026
Ad icon
ඉන්ටර්නෙට් එකෙන් හරියටම සල්ලි හොයන්න සහ Success වෙන්න කැමතිද? 🚀 (E-Money & Success Stories)
siri sumana
Updated:
May 30, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
Computers & Internet
Software Development
MySQL Pivot Table
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="ArunaTelshan" data-source="post: 23444600" data-attributes="member: 495249"><p><span style="font-size: 15px">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=":(" /></span></p><p><span style="font-size: 15px"></span></p><p></p><p></p><p><img src="https://i.imgur.com/TT1cC4K.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p></p><p><img src="https://i.imgur.com/an6i2ai.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p><span style="font-size: 15px"><span style="color: DarkRed">me wage ekak hadagannai one.</span></span></p><p></p><p><img src="https://i.imgur.com/iM6k95a.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>me mage query eka</p><p>[PHP]SELECT</p><p> student.stu_name,</p><p> SUM(IF(MONTH(fees.date) = 1, fees.amt, 0)) AS Jan,</p><p> SUM(IF(MONTH(fees.date) = 2, fees.amt, 0)) AS Feb,</p><p> SUM(IF(MONTH(fees.date) = 3, fees.amt, 0)) AS Mar,</p><p> SUM(IF(MONTH(fees.date) = 4, fees.amt, 0)) AS Apr,</p><p> SUM(IF(MONTH(fees.date) = 5, fees.amt, 0)) AS May,</p><p> SUM(IF(MONTH(fees.date) = 6, fees.amt, 0)) AS Jun,</p><p> SUM(IF(MONTH(fees.date) = 7, fees.amt, 0)) AS Jul,</p><p> SUM(IF(MONTH(fees.date) = 8, fees.amt, 0)) AS Aug,</p><p> SUM(IF(MONTH(fees.date) = 9, fees.amt, 0)) AS Sep,</p><p> SUM(IF(MONTH(fees.date) = 10, fees.amt, 0)) AS Oct,</p><p> SUM(IF(MONTH(fees.date) = 11, fees.amt, 0)) AS Nov,</p><p> SUM(IF(MONTH(fees.date) = 12, fees.amt, 0)) AS Dece,</p><p> SUM(fees.amt) AS Total,</p><p> (28000-(SUM(fees.amt))) AS Balance</p><p>FROM</p><p> fees</p><p>INNER JOIN student ON fees.stu_id = student.id</p><p>GROUP BY student.stu_id</p><p>WITH ROLLUP</p><p>[/PHP]</p></blockquote><p></p>
[QUOTE="ArunaTelshan, post: 23444600, member: 495249"] [SIZE="4"]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 :(:(:( [/SIZE] [IMG]https://i.imgur.com/TT1cC4K.jpg[/IMG] [IMG]https://i.imgur.com/an6i2ai.jpg[/IMG] [SIZE="4"][COLOR="DarkRed"]me wage ekak hadagannai one.[/COLOR][/SIZE] [IMG]https://i.imgur.com/iM6k95a.jpg[/IMG] 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 Balance FROM fees INNER JOIN student ON fees.stu_id = student.id GROUP BY student.stu_id WITH ROLLUP [/PHP] [/QUOTE]
Insert quotes…
Verification
Payakata winadi keeyak tibeda?
Post reply
Top
Bottom
🚀 GOOGLE AI PRO 18 MONTHS ACTIVATION 🚀
Pure VPN - Up to 27 Months
