10 Replies Latest reply: Apr 27, 2011 5:39 PM by deisouss RSS

    Create a Slideshow that pulls information from a database

    deisouss Community Member

      I want to create a slideshow banner that will showcase our products. The slideshow will contain the image of the product, the name, the price, the item code and the link when someone clicks on it. Each week we update the best sellers and it can be from 5 to 15 different products. Similar to what we have now in our website www.deiequipment.com which now is static, we want to animate it and rotate the products like a slideshow.

       

      The problem we are encountering is that we have to manually update the slideshow content.

       

      We would like to know if there is a way through scripting or catalyst to connect to a database and simply update all these fields automatically. So for example if the database has 5 items, automatically will pre-fill each field listed above and the slideshow will have 5 products.

       

      If we update the database now with 10 products, to update automatically. That way we can create 1 slide show, the time it takes to rotate to the next product, and add simple button controls to the slide show for next and back that will simply go through the loaded items.

       

      I tried to do a research on how to do it online but some takes me to scripting, others to catalyst dabases, but none are specific to what I need.

       

      As a note, the image will just be an image holder that will be updated with the image field in the database that points to the URL location of the image.

       

      Any help is greatly appreciated! thanks