Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getTotals($empID,$conf,$conn) {
- $string = "";
- $sql = "SELECT hours FROM {$conf['db_prefix']}_employees WHERE `id`='{$empID}' LIMIT 1";
- $result = mysql_query($sql);
- $row = mysql_fetch_assoc($result);
- $hours = $row['hours'];
- $string = "<p>Total Hours: {$hours} Hours";
- $sql2 = "SELECT hours FROM {$conf['db_prefix']}_time WHERE `empid`='{$empID}'";
- $result2 = mysql_query($sql2);
- $row2 = mysql_fetch_assoc($result2);
- $used = 0;
- foreach($row2 as $time) {
- $used = $used+$time;
- }
- $string .= "<br />\nUsed Hours: {$used} Hours";
- $left = $hours-$used;
- $string .= "<br />\nHours Left: {$left}</p>";
- return $string;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement