Show 4 products from a category as a slide show on mainpage

[vinnyna]

Is there a way to have a slide show a group of 4 products from each category on mainpage?
Thanks

[Website Rob]

Sure...with custom coding.

You would need to think through just exactly how you want it displayed, create the images to be used then hire someone as there is no module at this time that will do what you want.

[gjh42]

If you are willing and able to set it up yourself and don't need it to dynamically determine the categories and products to use, you could use one of the slideshow mods in Free Addons (like Ultimate Fade-in Slideshow) and make an instance of it for each category in define_main_page.php. That is basically a case of following directions, as long as you are good at following directions.

[green couch designs]

I did this which calls the images from a banner group Slider
which could probably be modified for your purposes

<!-- bof Easy Slider 1.7 -->
<div id="container">
<div id="content">
<?php

global $db;
$sql = "SELECT banners_title,banners_url,banners_image FROM ".TABLE_BANNERS." z where status='1' and banners_group ='Slider'";
$result = $db->Execute($sql);
$path = HTTP_SERVER.DIR_WS_CATALOG.DIR_WS_IMAGES;
if ($result->RecordCount() > 0) {
echo '<div id="slider"><ul>';
while (!$result->EOF) {

echo '<li><a href="'.($result->fields['banners_url']).'"><img src="'.$path.($result->fields['banners_image']).'" class="clip" title="'.($result->fields['banners_title']).'" /></a></li>';

$result->MoveNext();
}
echo '</ul></div>';
} else {
echo 'no value';
}
?>
</div>
</div>
<!-- eof Easy Slider 1.7 --><div class="clearBoth"></div>

[bn17311]

thanks for sharing this script it is excellent for slider

bryan

[Website Rob]

You really felt this thread needed to be edited? That's a bit too much totalitarian isn't it?