Sfrgttk

Was credit for the black hole image misattributed?

Button changing its text & action. Good or terrible?

How does ice melt when immersed in water

Separating matrix elements by lines

Can withdrawing asylum be illegal?

Why can't devices on different VLANs, but on the same subnet, communicate?

Make it rain characters

Arduino Pro Micro - switch off LEDs

Empty set is subset of every set? If yes, why that...

Why can't wing-mounted spoilers be used to steepen approaches?

Why do 2-stroke engines burn more oil?

Can the DM override racial traits?

How do you keep chess fun when your opponent constantly beats you?

Dash-to-Dock: How to remove these black stripes?

Name for abelian category in which every short exact sequence splits

How did passengers keep warm on sail ships?

Why is superheterodyning better than direct conversion?

Create an outline of font

How did the audience guess the pentatonic scale in Bobby McFerrin's presentation?

Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?

List only local user accounts with a single command

Semisimplicity of the category of coherent sheaves?

How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time

Is this wall load bearing? Blueprints and photos attached

Calculate the SUM amount in daily basis Expense in sql/php

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I want to get the total amount of Expenses in dail basis, if there is not Expeses posted/inserted THEN echo zero.

this is the Code i have tried

     <?php 



      $sql = "SELECT date(date) as td , COUNT(expense_id) AS num_expns , 

           FORMAT(SUM(amount),2) AS daily_total FROM expenses GROUP BY date(date)";



      $result = $connect->query($sql);



  while($row = $result->fetch_array()) {

  $tAmount=$row['daily_total'];

  $td=$row['td'];



  } // while



 ?>

mysql php

share

asked 2 mins ago

emma mfinangaemma mfinanga

1

New contributor

emma mfinanga is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I want to get the total amount of Expenses in dail basis, if there is not Expeses posted/inserted THEN echo zero.

this is the Code i have tried

     <?php 



      $sql = "SELECT date(date) as td , COUNT(expense_id) AS num_expns , 

           FORMAT(SUM(amount),2) AS daily_total FROM expenses GROUP BY date(date)";



      $result = $connect->query($sql);



  while($row = $result->fetch_array()) {

  $tAmount=$row['daily_total'];

  $td=$row['td'];



  } // while



 ?>

mysql php

share

asked 2 mins ago

emma mfinangaemma mfinanga

1

New contributor

emma mfinanga is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I want to get the total amount of Expenses in dail basis, if there is not Expeses posted/inserted THEN echo zero.

this is the Code i have tried

     <?php 



      $sql = "SELECT date(date) as td , COUNT(expense_id) AS num_expns , 

           FORMAT(SUM(amount),2) AS daily_total FROM expenses GROUP BY date(date)";



      $result = $connect->query($sql);



  while($row = $result->fetch_array()) {

  $tAmount=$row['daily_total'];

  $td=$row['td'];



  } // while



 ?>

mysql php

share

asked 2 mins ago

emma mfinangaemma mfinanga

1

New contributor

emma mfinanga is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

     <?php 



      $sql = "SELECT date(date) as td , COUNT(expense_id) AS num_expns , 

           FORMAT(SUM(amount),2) AS daily_total FROM expenses GROUP BY date(date)";



      $result = $connect->query($sql);



  while($row = $result->fetch_array()) {

  $tAmount=$row['daily_total'];

  $td=$row['td'];



  } // while



 ?>

share

asked 2 mins ago

emma mfinangaemma mfinanga

1

New contributor

emma mfinanga is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 2 mins ago

emma mfinangaemma mfinanga

1

New contributor

emma mfinanga is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

emma mfinangaemma mfinanga

1

New contributor

emma mfinanga is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

emma mfinangaemma mfinanga

1