Using php next to Category descriptions

[retched]

I'm trying to run a block of PHP code on the category descriptions page. I set this to be the categories description but it doesn't seem to execute, it just displays it instead. Can anyone help? Here is the code:

<?php  
 if ($featured_products->RecordCount() > 0) {
   for ($i = 0; $i < $featured_products->RecordCount(); $i++) {
   echo '<div class="categoryListBoxContents" style="width:33%;">';
   echo '<a href="' . zen_href_link(FILENAME_DEFAULT, 'main_page=product_info&products_id=' . $featured_products->fields['products_id']) . '">';
   echo zen_get_products_image($featured_products->fields['products_id']);
   echo '</A></div>';     
} 
} ?>

[kobra]

I'm trying to run a block of PHP code on the category descriptions page.

I believe that only html is allowed in the description block

[DrByte]

I don't understand what you're trying to do with the code you posted.

[retched]

I don't understand what you're trying to do with the code you posted.

I forgot to post up the MySQL coding that I put in header.php

   $featured_products_query = "SELECT feature.products_id, product_info.products_image, product_info.products_price, product_desc.products_name FROM " . TABLE_FEATURED . " as feature, " . TABLE_PRODUCTS . " as product_info, " .  TABLE_PRODUCTS_DESCRIPTION . " as product_desc, " . TABLE_PRODUCTS_TO_CATEGORIES . " as ptc WHERE feature.products_id = product_info.products_id AND feature.products_id = product_desc.products_id and feature.products_id = ptc.products_id AND ptc.categories_id = :categoriesID ORDER BY rand() LIMIT 3";
   $featured_products_query = $db->bindVars($featured_products_query, ':categoriesID', $current_category_id, 'integer');

   $featured_products = $db->Execute($featured_products_query); 

Essentially, look at featured products for all products within a given category (the category that the user is looking at). Select three at random and return the row values as defined above. (Product ID, image, price, and name).

The code in the original post, generally cycles through the data and returns the row values for it.

[Kim]

Doesn't the Featured Products block already do that?

[gjh42]

So essentially, an additional featured centerbox but inside the description. Why don't you want to use the regular featured centerbox (set to three products)?

[retched]

So essentially, an additional featured centerbox but inside the description. Why don't you want to use the regular featured centerbox (set to three products)?

I actually forgot that was there but wanted to embed it in the description along with some other stuff.

[retched]

So essentially, an additional featured centerbox but inside the description. Why don't you want to use the regular featured centerbox (set to three products)?

To further:

- I used the center box but it doesn't randomly select three products, it just selects the first three available.
- The parent category is show for the header, not the child where it's located.
- The configuration places the center box below the product listing, not above where I'm trying to get it to show. (I know how to fix this one but was hoping on something not involving me ripping into ZenCart too much).

Is an example: http://www.justuptowngames.com/index...x&cPath=1_2_61

[rbarbour]

I too am also looking to use PHP in my categories description but for different reason. Can this be done?

[DrByte]

What retched is doing is not actually including PHP *in* the category descriptions, but rather including additional content to be displayed via the template directly above/below the category description when the category description is displayed.

You can do the same simply by altering your template files as needed.

However, embedding PHP code into the actual HTML of the category description via your admin is NOT supported in Zen Cart.