Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- echo $postosstring;
- $procura1 = mysqli_query($link, "SELECT * FROM faturacoes where Status = 1 AND Data >= '$datainicial' AND Data <= '$datafinal' AND posto IN ('.$postosstring.')");
- // Total Contratos
- $resultset1 = mysqli_query($link, "SELECT SUM(contratos) as contratos FROM faturacoes where status='1' AND Data >= '$datainicial' AND Data <= '$datafinal' AND posto IN ('.$postosstring.')");
- $linha1= mysqli_fetch_assoc($resultset1);
- $soma1 = $linha1['contratos'];
- // Total Valor
- $resultset2 = mysqli_query($link, "SELECT SUM(valor) as valor FROM faturacoes where Status = 1 AND Data >= '$datainicial' AND Data <= '$datafinal' AND posto IN ('.$postosstring.')");
- $linha2= mysqli_fetch_assoc($resultset2);
- $soma2 = $linha2['valor'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement