需要从MySQL数据库获取今天的结果

So, I'm trying to show people who work for me how much they're making for that day... anyway you could tell me why this just gives me a "0" return?

$sql = "
SELECT SUM(money_earned) as money_earned 
  FROM staff_pay 
 WHERE DATE(time_charged)=CURDATE() 
   AND staff_id={$_SESSION['staff_id']}
";

Try this

$sid = $_SESSION['staff_id'];
$sql = "
SELECT  SUM(money_earned) as money_earned 
FROM staff_pay 
WHERE DATE(time_charged)=CURDATE() 
AND staff_id=$sid";