Смена фото при наведении в списке товаров категории - Дизайн и оформление

<?php
		$jshopConfig = JSFactory::getConfig();
		$db = JFactory::getDBO();
		$Query = "SELECT image_name FROM #__jshopping_products_images WHERE product_id = {$product->product_id} LIMIT 2";
		$db->setQuery($Query);
		$prodimg = $db->loadObjectList();
		if (count($prodimg)){ 
				foreach($prodimg as $primg) {
							print "<a title='{$product->name}' class='screenshot lightbox' href='{$product->product_link}'>";
							print "<img src='{$jshopConfig->image_product_live_path}/thumb_{$primg->image_name}'/></a>";
							
					}		
		}
		else {
			print "<a href='{$product->product_link}'><img src='{$jshopConfig->image_product_live_path}/noimage.gif'/></a>";
		}
	?>

<script>
jQuery(document).ready(function(){
   jQuery("div.three_img").each(function(index){jQuery(this).find("a.screenshot img:first").css("display","block");});
   jQuery("div.three_img").hover(
   function()
   {
      jQuery(this).find("a.screenshot img:last").css("display","block");
      jQuery(this).find("a.screenshot img:first").css("display","none");
   },
   function()
   {
   jQuery(this).find("a.screenshot img:first").css("display","block");
      jQuery(this).find("a.screenshot img:last").css("display","none");
   });
});
</script>

ORDER BY ordering ASC

$Query = "SELECT image_name FROM #__jshopping_products_images WHERE product_id = {$product->product_id} LIMIT 2 ORDER BY ordering ASC";

ORDER BY ordering ASC LIMIT 2

$db = JFactory::getDBO();		
$Query = $db->getQuery(true);
$Query->select('image_name');
$Query->from('#__jshopping_products_images');
$Query->where('product_id = '. $pid);
$Query->order('ASC');
$Query->limit('2');
$db->setQuery($Query);

$jshopConfig = JSFactory::getConfig();
		$db = JFactory::getDBO();
		
		$pid = $product->product_id;
		$Query = $db->getQuery(true);
		$Query->select('image_name');
			$Query->from('#__jshopping_products_images');
			$Query->where('product_id = '.$pid);
			$Query->order('ASC');
			$db->setQuery($Query, $offset = 0, $limit = 2);
$prodimg = $db->loadObjectList();

$Query->order('ordering ASC');

<?php
$jshopConfig = JSFactory::getConfig();
$db = JFactory::getDBO();
$Query = "SELECT image_name FROM #__jshopping_products_images WHERE product_id = {$product->product_id} LIMIT 2";
$db->setQuery($Query);
$prodimg = $db->loadObjectList();
if (count($prodimg)){
$i = 1;
foreach($prodimg as $primg) {
print "<a title='".$product->name."' class='screenshot-".$i++." lightbox' href='".$product->product_link."'>";
print "<img src='".$jshopConfig->image_product_live_path."/thumb_".$primg->image_name."'/></a>";
}
}
else {
print "<a href='".$product->product_link."'><img src='".$jshopConfig->image_product_live_path."/noimage.gif'/></a>";
}
?>

<?php if(i++ == 2) echo "class" ?> 

foreach($images as $key=>$image) {
    if ($key == 1) { // 1 - это второе изображение, потому что отсчет идет с 0
    }
}

<?php if (count($prodimg)) {?>
					<?php $i = 1; foreach($prodimg as $primg) {?>					
						<div class="uk-background-cover uk-position-cover"<?php if( $i++ == 2) print ' hidden id="second-img_'.$product->product_id.'"' ?> data-src="<?php print $jshopConfig->image_product_live_path."/".$size.$primg->image_name ?>" data-uk-img></div>
					 <?php }?>
					 <?php } else {?>
						<div class="uk-background-cover uk-position-cover uk-transition-opaque uk-transition-scale-up" data-src="/components/com_jshopping/templates/balou_uikit3/images/noimage.gif" data-uk-img></div>
					<?php }?>

<?php
$jshopConfig = JSFactory::getConfig();
$db = JFactory::getDBO();
$Query = "SELECT image_name FROM #__jshopping_products_images WHERE product_id = {$product->product_id} LIMIT 2";
$db->setQuery($Query);
$prodimg = $db->loadObjectList();
if (count($prodimg)){
$i = 1;
foreach($prodimg as $primg) {
print "<a title='".$product->name."' class='screenshot lightbox' href='".$product->product_link."'>";
print "<img id='img-".$i++."_".$product->product_id."' src='".$jshopConfig->image_product_live_path."/thumb_".$primg->image_name."'/></a>";
}
}
else {
print "<a href='".$product->product_link."'><img src='".$jshopConfig->image_product_live_path."/noimage.gif'/></a>";
}
?>

$img_hidden = "";
if($i++ == 2){
   $img_hidden = "hidden";
}

<?php $i = 1; $img_hidden = ""; if($i++ == 2){ $img_hidden = "hidden";
} foreach($prodimg as $primg) {?>

if($i++ == 2){
   $img_hidden = "hidden";
}