Fetch Reattempt and Hold Date count in efficient way
You can create one query and select all elements. For example:

select sum(case when DATE(reattemptdate) = CURDATE() THEN 1 ELSE 0 END) as reattemptdate,
       sum(case when DATE(holddate) = CURDATE() THEN 1 ELSE 0 END) as holddate,
       sum(case when DATE(reattemptdate) = DATE(NOW() - INTERVAL 1 DAY) THEN 1 ELSE 0 END) as prev_reattemptdate,
       sum(case when DATE(holddate) = DATE(NOW() - INTERVAL 1 DAY) THEN 1 ELSE 0 END) as prev_holddate
from orders;


php:

$results = $db_handle-&gt;runSelectQuery($sql); 
$reattemptdate =$results[0]['reattemptdate'];  
$holddate =$results[0]['holddate'];
$prevReattemptdate =$results[0]['prev_reattemptdate'];
$prevHolddate =$results[0]['prev_holddate'];
// display counters
echo $reattemptdate;
echo $holddate;
echo $prevReattemptdate;
echo $prevHolddate;