Why am I getting this parse error

[jimmygreaves]

Hi kids........

 

I'm trying to amend a module contribution - New Products Box Displays By Category - but I keep getting a parse error and cant figure out why. Would you check out my code and see if you can spot my (most likely, elementary) mistake.

 

In it's out of the box state the contribution works great but doesn't display the product name, I'm attempting to rectify this.

 

Here's my code..........

 

<?php
 $info_box_contents = array();
 $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));

// new contentBoxHeading($info_box_contents);

if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
$category_query = tep_db_query("select distinct categories_id from ". TABLE_PRODUCTS_TO_CATEGORIES );
$cids = array();
while ($categories = tep_db_fetch_array($category_query)) {
	array_push($cids, $categories["categories_id"]);
}
$cid = $cids[rand(0, count($cids) - 1)];

  // removed order by p.products_date_added desc
$new_products_query = tep_db_query(
	"select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, " .
		"if(s.status, s.specials_new_products_price, p.products_price) as products_price " .
	"from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " .
	TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' .		
	", " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c " .   
			"where p.products_id = p2c.products_id and products_status = '1' and (p2c.categories_id = 39 or p2c.categories_id = 39 or p2c.categories_id = 39)" .

	"order by rand() limit " . '3');



 } else {
$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by rand() limit " . MAX_DISPLAY_NEW_PRODUCTS);
 }

 $row = 0;
 $col = 0;
 $info_box_contents = array();
 while ($new_products = tep_db_fetch_array($new_products_query)) {
$info_box_contents[$row][$col] = array('align' => 'left',
									   'params' => 'class="main" width="33%" valign="top"',
									   'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], 125, 125, 'class="featuredImg"') . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])));

$col ++;
if ($col > 2) {
  $col = 0;
  $row ++;
}
 }

 new contentBox($info_box_contents);
?>

 

Thanks in advance.......