Latest ads

Ad icon
Jobreceive.com for sale
- Blogerwiki
- Updated: Tuesday at 8:55 PM
Post Your Vehicle for Sale — FREE! - https://libro.lk
- Kalu_Puth
- Updated: Tuesday at 7:38 PM
ඔයාගෙ Assignment හෝ Thesis එක හරියට හදාගමු
- ErMurazor
- Updated: Saturday at 10:52 PM
Ad icon
BlackWall V2ray servers
- hu KANNA
- Updated: Sep 23, 2026
Peppa Pig Family Plush Toy Set – 5 Characters
- anil1961
- Updated: Sep 19, 2026

Reply to thread

Message: <blockquote data-quote="Tharakadj" data-source="post: 23099596" data-attributes="member: 201091"><p><strong>PHP SQL වැඩකාරයො ඒන්න</strong></p><p></p><p><span style="color: Purple"><strong><span style="font-size: 15px">Machanla mata me query eka run karala me process eka wena ona. Price average ekak penana system ekak tiyenne SQL AVG use karane natuwa. data base eke data tiyenakota aulak natuwa penanawa. data empty unama NAN kiyala error ekak enawa.</span></strong></span></p><p></p><p><span style="font-size: 15px"><span style="color: Red">$Select_total_earning1="SELECT SUM(ORDER_TOTAL_PRICE) FROM orders WHERE SP_ID='$userID' AND ORDER_STATUS='COMPLETED'";</span></span></p><p><span style="font-size: 15px"><span style="color: Red"></span></span></p><p><span style="font-size: 15px"><span style="color: Red">$Select_total_orders="SELECT COUNT(ORDER_ID) FROM orders WHERE SP_ID='$userID' AND ORDER_STATUS='COMPLETED'";</span></span></p><p><span style="font-size: 15px"><span style="color: Red"></span></span></p><p><span style="font-size: 15px"><span style="color: Red">                              $result_total_earning1=$conn->query($Select_total_earning1);                            $result_total_orders=$conn->query($Select_total_orders);</span></span></p><p><span style="font-size: 15px"><span style="color: Red"></span></span></p><p><span style="font-size: 15px"><span style="color: Red">$rowprice = $result_total_earning1->fetch_assoc();</span></span></p><p><span style="font-size: 15px"><span style="color: Red">$roworder = $result_total_orders->fetch_assoc();</span></span></p><p><span style="font-size: 15px"><span style="color: Red"></span></span></p><p><span style="font-size: 15px"><span style="color: Red">$tot_price=(float)$rowprice["SUM(ORDER_TOTAL_PRICE)"];</span></span></p><p><span style="font-size: 15px"><span style="color: Red">$tot_order=(float)$roworder["COUNT(ORDER_ID)"];</span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple">(mama metanata float kiyala dame pase eka hari giyet na)</span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red">$avg=$tot_price/$tot_order;</span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red"><span style="color: Purple">(meka tamai line 204)</span></span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red"></span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red">echo $avg;</span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red"></span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red"><span style="color: purple">methiyenne error eka</span></span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red">"</span></span></span></span><strong><strong>Warning</strong>: Division by zero in <strong>C:\xampp\htdocs\test\test1\test.php</strong> on line <strong>204</strong></strong></p><p><strong>Rs. nan</strong></p><p></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red">"</span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red"></span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red"><span style="color: purple">mama net eke search karama nam awe nan kiyane numeric value ekak nemei unama ena error ekak kiyala.</span></span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red"><span style="color: purple"></span></span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red"><span style="color: purple">dana kenek help ekak karana. bump ekak wat dala yanna.</span></span></span></span></span></p><p><span style="font-size: 15px"><span style="color: Red"><span style="color: purple"><span style="color: Red"><span style="color: purple"></span></span></span></span></span></p></blockquote><p></p>

Verification: Asuwa dahayen wadi kalama keeyada?

Top Bottom