azmicolejr

berats,php (total ongkir)

Jan 30th, 2015
269
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. <?php
  2. if (ISSET($_SESSION['userlogin']))
  3. {
  4. include("config.php");
  5. $user = $_SESSION['userlogin'];
  6. $query = "SELECT sum(jumlah_berat) AS totalberat FROM transaksirincitbl INNER JOIN barangtbl ON barangtbl.id = transaksirincitbl.id
  7. INNER JOIN transaksitbl ON transaksitbl.notransaksi = transaksirincitbl.notransaksi
  8. WHERE transaksirincitbl.username='".$user."' AND transaksitbl.status ='0'";
  9. $hasil = mysql_query($query);
  10. $data = mysql_fetch_assoc($hasil);
  11.  
  12. if ($hasil > 0)
  13. {
  14. echo ceil($data['totalberat']);
  15. }
  16. }
  17. ?>
Advertisement
Add Comment
Please, Sign In to add comment