Mysql Time Card Calculator

[duttydea]

How can i adapt this cade to pull the times from  my mysql database?

 

Fields:

Start (Start Time) eg. 06:00:00

Finish (Finish Time) eg. 16:00:00

Lunch ([Either Yes or No] Yes ill deduct an hour from the overall calculation)

 

<?
$lunchflag = false; //true if lunch taken

echo "date 1:" . $datebegin . "<br />";
echo "date 2:" . $dateend . "<br />";

$diff = $dateend - $datebegin;

$hours = floor($diff / (60 * 60));
$minutes = ($diff % (60 * 60)) / 60; //for nice round minutes you can round(), floor() or ceil()

$hours = $lunchflag?$hours - 1:$hours;

echo $hours . ":" . $minutes;
?>

 

Thanks In advance