Request for withdrawal calculation from a certain date

Started by brandsmith, Sep 10, 2022, 12:53 AM

Previous topic - Next topic

brandsmithTopic starter

Hello. There was a need to create a request to calculate the balance from the table, the bottom line is that I need a code that will take from 1 table in phpmyadmin the values from the replenishment from the date 1658966420 for some person, calculate the total value and output it.

generally, AND `date`>'1658966420' how to output from the database only with a date from that one?


There are no tables and values in phpmyadmin. phpmyadmin displays what is in the MySQL database. It's like there is no forum in the browser, and its files are located somewhere on the server. The browser only displays pages based on our requests.
There are not enough introductory ones. And I'm not a psychic. For instance, like that:

$time = date("Y-m-d", time());
$d=date('Y-m-d H:i:s');
$time = new date-time($d);
#reducing the current server time by one day
$time->change("-1 day");
$time = $time->format('Y-m-d H:i:s');
$login= "test";
$query="SELECT * FROM `users`, WHERE `login` = '$login' AND `time`>'$time' ORDER BY `time` Time limit 50";