Latest ads

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
Gemini AI PRO 18 months Offer
- Hawaka
- Updated: May 27, 2026
Ad icon
koko account
- DasunEranga
- Updated: May 27, 2026

Reply to thread

Message: <blockquote data-quote="ArunaTelshan" data-source="post: 23456570" data-attributes="member: 495249"><p><span style="font-size: 12px"><span style="color: #581845"></span></span></p><p><span style="font-size: 12px"><span style="color: #581845">katahari puluwanda mata meka php walata harawala denna..</span></span></p><p><span style="font-size: 12px"><span style="color: #581845"></span></span></p><p></p><p>[CODE]SET @sql = NULL;</p><p>SELECT</p><p>  GROUP_CONCAT(DISTINCT</p><p>    CONCAT(</p><p>      'SUM(CASE WHEN MonthYear = ''',</p><p>      MonthYear,</p><p>      ''' THEN total ELSE 0 END) AS ',</p><p>      MonthYear</p><p>    )</p><p>  ) INTO @sql</p><p>FROM (</p><p>  SELECT</p><p>    cid,</p><p>    DATE_FORMAT(duedate, '%b_%y') MonthYear,</p><p>    total</p><p>  FROM invoices</p><p>  WHERE duedate BETWEEN CAST('2013-01-01' AS DATE) AND CAST('2013-07-31' AS DATE)</p><p>  ORDER BY duedate</p><p>) src;</p><p></p><p>SET @sql = CONCAT("SELECT cid, ", @sql, "</p><p>                   FROM (</p><p>                     SELECT</p><p>                       cid,</p><p>                       DATE_FORMAT(duedate, '%b_%y') MonthYear,</p><p>                       total</p><p>                     FROM invoices</p><p>                     WHERE duedate BETWEEN CAST('2013-01-01' AS DATE) AND CAST('2013-07-31' AS DATE)</p><p>                     ORDER BY duedate</p><p>                   ) src</p><p>                   GROUP BY cid");</p><p></p><p>PREPARE stmt FROM @sql;</p><p>EXECUTE stmt;</p><p>DEALLOCATE PREPARE stmt;[/CODE]</p><p></p><p><span style="font-size: 12px"><span style="color: #581845"></span></span></p><p><span style="font-size: 12px"><span style="color: #581845"></span></span></p><p><span style="font-size: 12px"><span style="color: #581845">$query    = "SQL QUERY";</span></span></p><p><span style="font-size: 12px"><span style="color: #581845">$result    = mysqli_query($connection,$query);</span></span></p><p><span style="font-size: 12px"><span style="color: #581845"></span></span></p><p><span style="font-size: 12px"><span style="color: #581845">me widiyata run karanna puluwan wena widiyata</span></span></p><p><span style="font-size: 12px"><span style="color: #581845"></span></span></p><p><span style="font-size: 12px"><span style="color: #581845"></span></span></p></blockquote><p></p>

Verification: Winadiyakata thappara keeyak tibeda?

Top Bottom