Advertisement
Guest User

Untitled

a guest
Jan 20th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. echo $postosstring;
  2.  
  3. $procura1 = mysqli_query($link, "SELECT * FROM faturacoes where Status = 1 AND Data >= '$datainicial' AND Data <= '$datafinal' AND posto IN ('.$postosstring.')");
  4.  
  5. // Total Contratos
  6.  
  7. $resultset1 = mysqli_query($link, "SELECT SUM(contratos) as contratos FROM faturacoes where status='1' AND Data >= '$datainicial' AND Data <= '$datafinal' AND posto IN ('.$postosstring.')");
  8.  
  9. $linha1= mysqli_fetch_assoc($resultset1);
  10.  
  11. $soma1 = $linha1['contratos'];
  12.  
  13. // Total Valor
  14. $resultset2 = mysqli_query($link, "SELECT SUM(valor) as valor FROM faturacoes where Status = 1 AND Data >= '$datainicial' AND Data <= '$datafinal' AND posto IN ('.$postosstring.')");
  15.  
  16.  
  17. $linha2= mysqli_fetch_assoc($resultset2);
  18.  
  19. $soma2 = $linha2['valor'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement