如何使javascript在SQL while循环中回显所有数据

所以我试图为我的脚本做一个计时器，但它只倒计时最后一个结果，而不是所有结果，并且对于从查询返回的所有结果，都显示从最后一个开始的倒计时。如有任何帮助，我们将不胜感激。感谢

<?php 
$q = $handler->prepare("SELECT * FROM pending_payments WHERE user_id = ? AND status = ?");
$q->bindParam(1, $session_id);
$q->bindParam(2, $pending);
$q->execute();
if($q->rowCount() > null){
?>                      
                        <h4 class="title"> Pending Payment </h4>
                        <div class="squiggly-border"></div>
                        <table class="table table-index">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>Item</th>
                                    <th>Expires</th>
                                    <th></th>
                                </tr>
                            </thead>
                            <tbody>
<?php
while($r = $q->fetch()) {
$pending_payment_id = $r['id'];
$pending_item = $r['item'];
$pending_expiry = $r['expiry'];
?>
<script type="text/javascript">
var count = <?php if($dateUNIX < $pending_expiry){ echo $pending_expiry - $dateUNIX; } ?>;
var counter = setInterval(timer, 1000); //1000 will  run it every 1 second
function timer() {
    count = count - 1;
    if (count == -1) {
        clearInterval(counter);
        return;
    }
    var seconds = count % 60;
    var minutes = Math.floor(count / 60);
    var hours = Math.floor(minutes / 60);
    minutes %= 60;
    hours %= 60;
    document.getElementById("pEFTimer<?php echo $r['id'] ?>").innerHTML = hours + " hours " + minutes + " minutes "; // watch for spelling
}
</script>                           
                                <tr>
                                    <td class="text"><?php echo $pending_payment_id; ?></td>
                                    <td class="text"><?php echo $pending_item ?></td>
                                    <td class="text" id="pEFTimer<?php echo $r['id'] ?>"></td>
                                    <td class="text"><a href="pendingPayment<?php echo $r['id']; ?>" ><button class="btn btn-success btn-xs">Proceed to Payment</button></a></td>
                                </tr>
<?php
}
echo '</tbody></table>';
}
?>