Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if (ISSET($_SESSION['userlogin']))
- {
- include("config.php");
- $user = $_SESSION['userlogin'];
- $query = "SELECT sum(jumlah_berat) AS totalberat FROM transaksirincitbl INNER JOIN barangtbl ON barangtbl.id = transaksirincitbl.id
- INNER JOIN transaksitbl ON transaksitbl.notransaksi = transaksirincitbl.notransaksi
- WHERE transaksirincitbl.username='".$user."' AND transaksitbl.status ='0'";
- $hasil = mysql_query($query);
- $data = mysql_fetch_assoc($hasil);
- if ($hasil > 0)
- {
- echo ceil($data['totalberat']);
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment