make "specials" module and "bestsellers" module always display

[Ajeh]

The top of the IF is being used when there is a category set based on the value of:
$current_category_id

If that isn't set, then the bottom half of the IF is used ...

What you want to do is after the $sql is run the add this IF below it to test if anything was found, and if not, run a copy of the same select that would be run had there been no $current_category_id defined with:

  if ($best_sellers->RecordCount () == 0) {
      $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
                             from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             where p.products_status = '1'
                             and p.products_ordered > 0
                             and p.products_id = pd.products_id
                             and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                             order by p.products_ordered desc, pd.products_name
                             limit " . MAX_DISPLAY_BESTSELLERS;
  }

You should be able to add that just above the:

} else {

see if that gets what you are looking for ...

[DivaVocals]

So this fixed the page I was looking at (product info page), but didn't work here:
http://eitestsite(dot)eyeitalia(dot)...=index&cPath=5

but the three subcategories of this are working as expected:
http://eitestsite(dot)eyeitalia(dot)...dex&cPath=5_10
http://eitestsite(dot)eyeitalia(dot)...dex&cPath=5_12
http://eitestsite(dot)eyeitalia(dot)...dex&cPath=5_13

and just to be clear here's the changes to my best sellers code:

// test if box should display
  $show_best_sellers= false;

  if (isset($_GET['products_id'])) {
    if (isset($_SESSION['customer_id'])) {
      $check_query = "select count(*) as count
                      from " . TABLE_CUSTOMERS_INFO . "
                      where customers_info_id = '" . (int)$_SESSION['customer_id'] . "'
                      and global_product_notifications = '1'";

      $check = $db->Execute($check_query);

      if ($check->fields['count'] > 0) {
        $show_best_sellers= true;
      }
    }
  } else {
    $show_best_sellers= true;
  }

// bof: force best_sellers to always show
    $show_best_sellers= true;
// eof: force best_sellers to always show

  if ($show_best_sellers == true) {
    $limit = (trim(MAX_DISPLAY_BESTSELLERS) == "") ? "" : " LIMIT " . (int)MAX_DISPLAY_BESTSELLERS;
      if (isset($current_category_id) && ($current_category_id > 0)) {
      $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
                             from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
                                    . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c
                             where p.products_status = '1'
                             and p.products_ordered > 0
                             and p.products_id = pd.products_id
                             and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                             and p.products_id = p2c.products_id
                             and p2c.categories_id = c.categories_id
                             and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id)
                             order by p.products_ordered desc, pd.products_name";

      $best_sellers_query .= $limit;
      $best_sellers = $db->Execute($best_sellers_query);
      if ($best_sellers->RecordCount () == 0) {
      $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
                             from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             where p.products_status = '1'
                             and p.products_ordered > 0
                             and p.products_id = pd.products_id
                             and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                             order by p.products_ordered desc, pd.products_name
                             limit " . MAX_DISPLAY_BESTSELLERS;
  }
    } else {
      $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
                             from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             where p.products_status = '1'
                             and p.products_ordered > 0
                             and p.products_id = pd.products_id
                             and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                             order by p.products_ordered desc, pd.products_name";

[Ajeh]

Sorry ... I forgot a set ...

Immediately, after your new select statement for the $sql in RED it would be a good idea to run that $sql ... so add the line:

      $best_sellers = $db->Execute($best_sellers_query);

[DivaVocals]

Sorry ... I forgot a set ...

Immediately, after your new select statement for the $sql in RED it would be a good idea to run that $sql ... so add the line:

      $best_sellers = $db->Execute($best_sellers_query);

HA! That did the trick!!

You are soooooooooooo awesome!!!! Gonna add this post to my "Tips & Tricks" folder..

Thanks Linda.. as usual, you are a doll!!!

[Ajeh]

You are most welcome ... took me a minute to figure out why the simple select didn't work ... silly me ...

[DivaVocals]

You are most welcome ... took me a minute to figure out why the simple select didn't work ... silly me ...

No worries.. You are STILL the best!