Column Grid for Featured Products

[jensurge]

Ok I have checked out all the posts about the Column Grid add-on and how to make it work for the New Products, etc. I have gotten it to work with those because there was some clear explainations about how to go about fixing the problem. However, I only read how the code for the Featured Products is different but really no explaination about how to actually get it to work. I would appreciate it if someone could help me out with this.

I have tried a couple of different things one way I got a different product category to show up for the Featured Products and the other way I got an SQL error stating that the query for ":languagesID" was resulting in an error. Again like I said if there is anyone that could help me work this out I would greatly appreciate it.

Thanks
Jen

[kobra]

See if this might bring some clarity to what you seek

http://www.zen-cart.com/forum/showthread.php?t=84174&

[jensurge]

that was the post that I was referencing ... and the one that I used to get as far as I have gotten ... however, there are a few posts in there about others not being able to do the same technique in order to get the featured products category to work the same way. I was wondering if there was a posting or thread that showed what these people did to resolve this or not because I hadan't found the answer.

Thanks

[jensurge]

This is my code for the /includes/modules/pages/featured_products/header_php.php

"SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,
  									 p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
                                 	 p.product_is_always_free_shipping, p.products_qty_box_status,
                                  p.master_categories_id
                                  FROM (" . TABLE_PRODUCTS . " p
                                  LEFT JOIN " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " .TABLE_PRODUCTS_DESCRIPTION . " pd
                                  LEFT JOIN " . TABLE_FEATURED . " f on pd.products_id = f.products_id )
                                  WHERE p.products_status = 1 and p.products_id = f.products_id and f.status = 1
                                  AND p.products_id = pd.products_id and pd.language_id = :languagesID " .
$order_by;

Here is my code for the includes/templates/MYTEMPLATE/templates/tpl_featured_products_default.php

 <?php
/**
 * Module Template
 *
 * @package templateSystem
 * @copyright Copyright 2003-2005 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: tpl_modules_product_listing.php 3241 2006-03-22 04:27:27Z ajeh $
 * UPDATED TO WORK WITH COLUMNAR PRODUCT LISTING 04/04/2006
 */
require($template->get_template_dir('/tpl_modules_listing_display_order.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_listing_display_order.php');
    require($template->get_template_dir('tpl_modules_product_listing.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_product_listing.php');
?>

As a result I get the following error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':languagesID' at line 5
in:
[select count(p.products_id) as total FROM (zen_products p LEFT JOIN zen_manufacturers m on (p.manufacturers_id = m.manufacturers_id), zen_products_description pd LEFT JOIN zen_featured f on pd.products_id = f.products_id ) WHERE p.products_status = 1 and p.products_id = f.products_id and f.status = 1 AND p.products_id = pd.products_id and pd.language_id = :languagesID ]

I have also tried a couple of other combinations that have also not successfully worked. Hopefully, this might also help in figuring out what the heck is going on and how I might be able to fix it

Thanks

[jensurge]

*bumping*

[jtlswan]

anyone?

[dremhmrk2]

bump myself

[dimsumgurl]

Im also looking for a solution to this. I am able to get the grid lines to appear on most listings except the new products and featured.