Howto Add class=selected to curent product image in sidebox when on product info page

Hello again.

Im using a litle moded prolist sidebox wich displays all products of curent category when you are on product info page.
However I want to add class=selected to the curent product image in the prolist sidebox when on cirent product product info page.

example page

the prolist sidebox is in the left sidebar, and there are several images of products from the same category. I want to add class="selected" to the image witch ID is the same as the curent product info ID

here is the code in prolist.php located in my modules/sidebox page

<?php
if (($current_page_base == 'product_info') and ((in_array($cPath,explode(",",'133,122'))) or strpos($cPath, '134_') === 0)){
    require($template->get_template_dir('tpl_prolist.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes') . '/tpl_prolist.php');
    $title .= '↓ Върни се към ↓<br/><a href="' . zen_href_link(FILENAME_DEFAULT, 'cPath=' . $_GET['cPath'], 'NONSSL') . '" title="' .zen_get_categories_name((int)$current_category_id). '" >' . zen_get_categories_name((int)$current_category_id) .  '</a><br/>';
    $title_link = false;

    require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);}
	
	elseif ($_GET["main_page"]=="product_info"){
    require($template->get_template_dir('tpl_prolist.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes') . '/tpl_prolist.php');
$allowed4 = array_merge(range('a', 'z'), range('A', 'Z'),range(0, 9), array(' ', '+', '/', '-', '*'));
	$strippedcat2 = zen_get_categories_name((int)$current_category_id);
	$array4 = str_split($strippedcat2);
    $title .= '↓ Върни се към ↓<br/><a href="' . zen_href_link(FILENAME_DEFAULT, 'cPath=' . $_GET['cPath'], 'NONSSL') . '" title="' .implode('', array_intersect($array4, $allowed4)). '" >' . implode('', array_intersect($array4, $allowed4)) .  '</a><br/>';
    $title_link = false;

    require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);}

?>

and here the code in my tpl_prolist.php dile in templates directory

<?php
if (($current_page_base == 'product_info') and ((in_array($cPath,explode(",",'133,122'))) or strpos($cPath, '134_') === 0)){
    require($template->get_template_dir('tpl_prolist.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes') . '/tpl_prolist.php');
    $title .= '↓ Върни се към ↓<br/><a href="' . zen_href_link(FILENAME_DEFAULT, 'cPath=' . $_GET['cPath'], 'NONSSL') . '" title="' .zen_get_categories_name((int)$current_category_id). '" >' . zen_get_categories_name((int)$current_category_id) .  '</a><br/>';
    $title_link = false;

    require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);}
	
	elseif ($_GET["main_page"]=="product_info"){
    require($template->get_template_dir('tpl_prolist.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes') . '/tpl_prolist.php');
$allowed4 = array_merge(range('a', 'z'), range('A', 'Z'),range(0, 9), array(' ', '+', '/', '-', '*'));
	$strippedcat2 = zen_get_categories_name((int)$current_category_id);
	$array4 = str_split($strippedcat2);
    $title .= '↓ Върни се към ↓<br/><a href="' . zen_href_link(FILENAME_DEFAULT, 'cPath=' . $_GET['cPath'], 'NONSSL') . '" title="' .implode('', array_intersect($array4, $allowed4)). '" >' . implode('', array_intersect($array4, $allowed4)) .  '</a><br/>';
    $title_link = false;

    require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);}

?>

Thanks in addvance

You posted the same code twice, not the template file.

oh yes sorry.

<?php
/**
 * Product Listing Sidebox
 *
 */

  $content = '';
  $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent">';
	
	$prolist_query = "select 

			products.products_image, products_description.products_name, products_to_categories.*, categories_description.categories_id
			
			from products, products_description, products_to_categories, categories_description
			
			where categories_description.categories_id = '$current_category_id'
			and categories_description.categories_id = products_to_categories.categories_id
			and products_description.products_id = products_to_categories.products_id
			and products.products_id = products_description.products_id
			
			order by products_description.products_name
			";
	
		$prolist = $db->Execute($prolist_query);
		
	 while (!$prolist->EOF) {
   	$content .=  '<a href="' . zen_href_link(zen_get_info_page($prolist->fields['products_id']), ($_GET['cPath'] > 0 ? 'cPath=' . $_GET['cPath'] . '&' : '') . 'products_id=' . $prolist->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $prolist->fields['products_image'], $prolist->fields['products_name'],SMALL_IMAGE_WIDTH*1.2, SMALL_IMAGE_HEIGHT*1.2, 'class="listingProductImage"') . '</a>';
   	$prolist->MoveNext();
   };
	
  $content .= '</div>';
	
	
?>

I tryed this

while (!$prolist->EOF) {
		 if ($prolist->fields['products_id'] = (int)$_GET['products_id']) {
   	$content .=  '<a class="selectedImg" href="' . zen_href_link(zen_get_info_page($prolist->fields['products_id']), ($_GET['cPath'] > 0 ? 'cPath=' . $_GET['cPath'] . '&' : '') . 'products_id=' . $prolist->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $prolist->fields['products_image'], $prolist->fields['products_name'],SMALL_IMAGE_WIDTH*1.2, SMALL_IMAGE_HEIGHT*1.2, 'class="listingProductImage"') . '</a>';
   	$prolist->MoveNext();}
	elseif ($prolist->fields['products_id'] = (int)$_GET['products_id']) {
   	$content .=  '<a href="' . zen_href_link(zen_get_info_page($prolist->fields['products_id']), ($_GET['cPath'] > 0 ? 'cPath=' . $_GET['cPath'] . '&' : '') . 'products_id=' . $prolist->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $prolist->fields['products_image'], $prolist->fields['products_name'],SMALL_IMAGE_WIDTH*1.2, SMALL_IMAGE_HEIGHT*1.2, 'class="listingProductImage"') . '</a>';
   	$prolist->MoveNext();}
   };

but it is givving the class="selectedImg" to the all images

Try this ...
(And of course you'll still need to add your .selectedImg selector to your stylesheet.)

<?php
/**
 * Product Listing Sidebox
 *
 */

  $content = '';
  $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent">';
    
    $prolist_query = "select 

            products.products_image, products_description.products_name, products_to_categories.*, categories_description.categories_id
            
            from products, products_description, products_to_categories, categories_description
            
            where categories_description.categories_id = '$current_category_id'
            and categories_description.categories_id = products_to_categories.categories_id
            and products_description.products_id = products_to_categories.products_id
            and products.products_id = products_description.products_id
            
            order by products_description.products_name
            ";
    
        $prolist = $db->Execute($prolist_query);
        
     while (!$prolist->EOF) {
[B]       $classHref = ($prolist->fields['products_id'] == $_GET['products_id']) ? ' class="selectedImg"' : '';
       $classImg = ($prolist->fields['products_id'] == $_GET['products_id']) ? ' selectedImg' : '';[/B]
       $content .=  '<a[B]' . $classHref . ' [/B]href="' . zen_href_link(zen_get_info_page($prolist->fields['products_id']), ($_GET['cPath'] > 0 ? 'cPath=' . $_GET['cPath'] . '&' : '') . 'products_id=' . $prolist->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $prolist->fields['products_image'], $prolist->fields['products_name'],SMALL_IMAGE_WIDTH*1.2, SMALL_IMAGE_HEIGHT*1.2, 'class="listingProductImage[B]' . $classImg . ' [/B]"') . '</a>';
       $prolist->MoveNext();
   };
    
  $content .= '</div>';

Thanks a lot DrByte it worked great.

Many, many thanks.

Hello again,

I want to do one last thing to this sideboxs. Is there a way to make the product that has class="selectedImg" first in the list?

It is not something essential but will be nice efect.

Thanks a lot again and many regards.

perfumbg:

I want to do one last thing to this sideboxs. Is there a way to make the product that has class="selectedImg" first in the list?
You said you're using the following SQL query:```
$prolist_query = "select

        products.products_image, products_description.products_name, products_to_categories.*, categories_description.categories_id
        
        from products, products_description, products_to_categories, categories_description
        
        where categories_description.categories_id = '$current_category_id'
        and categories_description.categories_id = products_to_categories.categories_id
        and products_description.products_id = products_to_categories.products_id
        and products.products_id = products_description.products_id
        
        order by products_description.products_name
        ";

To sort it and insert the currently-selected product at the top of the results, make the following changes: ```
    $prolist_query = "select [B]if(p.products_id = " . (int)$_GET['products_id'] . ", 0, 1) as sorter,[/B]

            products.products_image, products_description.products_name, products_to_categories.*, categories_description.categories_id
            
            from products, products_description, products_to_categories, categories_description
            
            where categories_description.categories_id = '$current_category_id'
            and categories_description.categories_id = products_to_categories.categories_id
            and products_description.products_id = products_to_categories.products_id
            and products.products_id = products_description.products_id
            
            order by [B]sorter, [/B]products_description.products_name
            ";