adding a message to special section

hello.
As part of navigation , i am adding Specials link to my nav. Problem is that , if there are no specials , center box is empty . i like to add a message saying something like sorry there are no special today. bla bla.

i like to know how i can do that .

Thanks.

any advice ??

If you look how the Categories sidebox manages this, you should be able to adapt the code for what you are doing ...

    if (SHOW_CATEGORIES_BOX_SPECIALS == 'true') {
      $show_this = $db->Execute("select s.products_id from " . TABLE_SPECIALS . " s where s.status= 1 limit 1");
      if ($show_this->RecordCount() > 0) {
        $content .= '<a class="category-links" href="' . zen_href_link(FILENAME_SPECIALS) . '">' . CATEGORIES_BOX_HEADING_SPECIALS . '</a>' . '<br />' . "\n";
      }
    }

Thank for the pointer . will try to make it work from here on . :)

i failed .. codes are not my thing . anyone with more straight forward code to solve this problem ? :unsure:

You may need to adjust this but see if it helps:

<?php
// bof: specials link
      $show_this = $db->Execute("select s.products_id from " . TABLE_SPECIALS . " s where s.status= 1 limit 1");
      if ($show_this->RecordCount() > 0) {
        echo '<li><a href="' . zen_href_link(FILENAME_SPECIALS) . '">' . 'Specials' . '</a>' . '</li>';
      }
// eof: specials link
?>

To give a message in the specials page if empty```php
$show_this = $db->Execute("select s.products_id from " . TABLE_SPECIALS . " s where s.status= 1 limit 1");
if ($show_this->RecordCount() !> 0) {

    echo 'There are no specials today.';

  }

Thank you both . I am kinda confused .. where is that code ? do i need to add it to a page ? which page and where exactly . .

sorry , to much drug in my system and I cANT tHINK Straight .. really :no: