asked on
$sql1="select a.message_total,b.message_sent from
( SELECT
batch_id, count(phone) message_total from to_numbers group by batch_id
) a left outer join
( SELECT
batch_id, count(phone) message_sent from message_sent group by batch_id
) b
on a.batch_id=b.batch_id
where a.batch_id=".$max_id."";
$out = '';
$result1 = mysqli_query($db, $sql1);
while($row = mysqli_fetch_row($result1))
{
$out .='<table class="table table-bordered"><tr><td width="30%"><label>message_total</label></td><td width="70%">'.$row['message_total'].'</td></tr><tr><td width="30%"><label>message_sent</label></td><td width="70%">'.$row['message_sent'].'</td></tr></table>';
}