Welcome Guest, Not a member yet? Register   Sign In
Sum of MySQL rows values and sum of values shouldn't be greater than php variable
#1

Hello! I use Codeigniter 3.1.11 and have a php variable [font=Monaco, Consolas, Courier, monospace]$maximum_amount [font=Tahoma, Verdana, Arial, sans-serif]with value of '[font=Monaco, Consolas, Courier, monospace]0.50000000'.[/font][/font][/font]

In my MySQL database I have a table called 'orders' with a rows for example:

Code:
#table orders
+----------+-----------+--------------+---------------------+
|  OrderID |   UserID  |  amount      |  created_time       |
+----------+-----------+--------------+---------------------+
|   a1bh   |    htl57  |  0.10000000  | 2020-07-27 08:23:11 |
|   2c3f   |    34gh7  |  0.30000000  | 2020-07-27 08:24:49 |
|   4d5s   |    lkr37  |  0.20000000  | 2020-07-27 08:29:03 |
|   5e6k   |    jkw68  |  0.50000000  | 2020-07-27 08:30:04 |
+----------+-----------+--------------+---------------------+

[font=Arial,]I need to select rows with SUM of 'amount' but the SUM of 'amount' shouldn't be be greater than variable [/font]$maximum_amount. I need to use order ASC by 'created_time' and limit '100'. I know what I need to use Cumulative Sum, but I don't know how to do it with Codeigniter. Please, help to solve this.
Reply


Messages In This Thread
Sum of MySQL rows values and sum of values shouldn't be greater than php variable - by olegrain - 07-28-2020, 02:03 AM



Theme © iAndrew 2016 - Forum software by © MyBB