Php code to update the profit column in database in every 1 hour I'm currently working web based hyip software but the problem I'm facing there is that I need a php code that will be increasing the user profit in every 1 hour but I still don't get it.
In that application, I have a table called ph_list whereby all deposit made by the user will be stored.
In that table, I have a column called the tracking_id(which is unique), Amount, Percentage...

But after making deposit, I want the amount donated by the user should be increasing in every 1 hour , which will be in percentage column....

Please I need someone to shield more light on this please!!
Never update it.  No UPDATE, noTRIGGER`.  Simply compute it based on the current time minus the time at which the user's entry was established.

There are standard formulas for "compound interest"; MySQL has all the math formulas needed to do the arithmetic.