Jump to content

Extra Field In Blockbestsellers


Recommended Posts



I have added an extra field in the database table 'product' containing a url link to a sound clip unique for each product. I want to pull this into some code so that a play button can be inserted into the top sellers and play the media from the link. I have the sound player working when I statically code in the clip link but cannot figure out how to bring in the data as part of the array so that I can use the field from the database in the {foreach} loop in blockbestsellers.tpl


I'm running v1.5.3.1


Any pointers would be gratefully received.



Edited by AshZS (see edit history)
Link to comment
Share on other sites

Ok found answer.


In file \classes\ProductSale.php on line 138 add newfield to SQL select query and then in \themes\default\modules\blockbestsellers\blockbestsellers.tpl add {$product.newfield} where needed.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...