Help me, How to coding php for display result

mrgman

Hi everybody
after query output from database(MySQL). How to coding php for display result

Day|Profit
1 |10
2 |10
3 |10

4 |10
5 |10
Sum 5 Day = 50

6 |10

7 |10
8 |10
9 |10
10 |10
Sum 10 Day = 100

11 |10
12 |10
13 |10
14 |10
15 |10
Sum 15 Day = 150

Day, Profit are record in database.......Help Me

leatherback

echo "Day|Profit ";

$sum = 0;

while($row=mysql_fetch_array($result))
  {
  echo $row['day']." | ".$row['profit']."<br />";
  $sum = $sum +$row['profit'];
  if($row['day']%5 == 0)
    {
    echo 'Sum: '.$sum;
    $sum = 0;
    }
  }

mrgman

Thank leatherback very much 😃

If I wanted result display. How to coding 😕

Day|Profit
1 |10
2 |10
3 |10
4 |10
5 |10
Sum 5 Day = 50

6 |10
7 |10
8 |10
9 |10
10 |10
Sum 5 Day = 50

11 |10
12 |10
13 |10
14 |10
15 |10
Sum 50 Day = 50

Total 15 Day 150

leatherback

What did I sent you?

mrgman

Uhm......Yes, first problem has solved 😃

If I wanted result display. sum has every 5 day how to coding 🙂

Day|Profit
1 |10
2 |10
3 |10
4 |10
5 |10
Sum 5 Day = 50

6 |2
7 |5
8 |5
9 |5
10 |8
Sum 5 Day = 25

11 |10
12 |20
13 |8
14 |2
15 |15
Sum 50 Day = 55

Total 15 Day 130

leatherback

Sorry Mrgman,

Besides obvious differences in little stylngs, I do not understand what is different between the code I posted and what you are showing now. Be clear in what you are asking, and show us how you have worked with what I posted earlier

JVassie

leatherback, i think he is looking for a way to total all 15 days.

But im pretty sure you've already given that haven't you? 😕

leatherback

well... Ehm.. I have given him a way to total 5 days. It is not rocket science to go to total for 15 days from there. I am not a consultant on a silly salary. People need to give it a go too.

mrgman

Sorry Sorry , I 'm not clear ...........
1. How to coding php for display result ?
- Sum 1-5 day, 1-10 day, 1-15 day
Uhm... first problem has solved (yes for me) 😃

How to sum every 5 days?
sum 1-5 days = x1
sum 6-10 days = x2
sum 11-15 days = x3
total all 15 days = x1+x2+x3

I understood with concept but. I don't know start coding. I'm beginner :p

leatherback

did you run the code? Did you try it? Adjust it to your specific needs? All that you need should be there. If you did, and still have trouble, show us what you did and what is giving you trouble.

The only line you might need in addition to what I posted before is in the while loop:
$o veralcount = $overallcount+$row['profit']; but frankly.. I'd think you should be able to deduct that from the earlier post.

I am not sure what you are asking.