errno) { throw new Exception('Couldn\'t connect to database'); } $query = "SELECT i.code, i.description, i.used FROM bill2coupon AS i WHERE i.description = '4july' AND i.used = 0"; if($ps = $db->prepare($query)) { //$ps->bind_param('ii', $qcfDate, $qctDate); $ps->execute(); $ps->bind_result( $code, $description, $used ); //LOOP RESULTS while($ps->fetch()) { $couponArray[$code] = true; } $ps->close(); } else { die('prepare() failed: ' . htmlspecialchars($db->error)); } $randomCoupon = array_rand($couponArray); if(count($randomCoupon) > 0) { echo '

'; echo 'Click code to claim

'; echo '' . $randomCoupon . '

'; } else { echo '

'; echo 'Click code to claim

'; echo 'Sorry, all coupons claimed!

'; } } else { echo '

Campaign closed.

'; } ?>