I managed to get it to work in the end with this code:
Code:
<?php
// Get todays date
$today = date("Y-m-d");
// Retrieve Weekly Special Rate
$week_special_rate_query = exc_db_query("SELECT week_special_rate FROM calendar_weeks WHERE week_special_rate > '0' AND start_date >= '" . $today . "'");
$week_special_rate_array = exc_db_fetch_array($week_special_rate_query);
// Show Last Minute Deals button only if there are any deals to display
if (exc_not_null($week_special_rate_array['week_special_rate'])) {
?>