Please help me to find solution that when I try code in mysql database it working best but I don't know how to use it in PHP to fetch in android app. SELECT cus_mobile, cus_name, SUM(sel_cost) FROM bus_selling_receive GROUP BY cus_mobile ORDER BY sel_cost DESC this code I want to use in php. How to use.
How can I reward you for this video? Thank you very much man. Firebase was so complicated to get real time data, but from this your video, a bug I have been trying to fix about 5 days ago is now working 100%.
There are 2 problems here - 1) Each visitor to your page will be querying your database every second with no caching. This will significantly impact the performance of your server. 2) It will take 1 second for your data to populate when the page first loads.
But as of mysql version 8.0 ( I think ) they have removed the cache system completely and I wonder is it because its not up to date anymore? Aren't there other ways to increase query performance for the mysql database?
I got answer 🤣😂🤣😂🤣 myself 1) How to find data from 2 tables Ans : copy paste the php code down and change table name and rows name 😂🤣😂👻 game over in backend bcoz UNION is not working