Welcome, Guest. Please login or register.
Login with username, password and session length


It's a release candidate! VirtueMart 2.0 RC - the next generation VirtueMart - is available! Read more....

  Advanced search

247038 Posts in 67506 Topics- by 258314 Members - Latest Member: aniketana
Pages: [1]   Go Down
Print
Author Topic: How to add custom fields to product_details/flypage based on a query to a new  (Read 6092 times)
micper2050
Newbie
*
Posts: 23


« on: October 27, 2006, 08:14:47 AM »


I would like to present on the detail description of the flypage a list of the songs titles present on several  album CD which are declared as products in Virtuemart. The query shall be filtered with the function WHERE with a probable a JOIN function between Product_id of  VM product table and the new created table jos_vm_mp3.album_id

I understand so far that  this query can be added in shop_product_details.php with  the tags at the end of the list .

In the fly page
Add the new created tags – {track} – {title}-{album} and a play link for each with Href function which enable each title to be played in a Mp3 player.

As I am not expert in Php I need some advise or help how I can create the query to the DB and added table jos_vm_mp3 and how to join with the jos_vm_product to get a filtering of the datas (title) for each album.
Thank you for your help.
Logged
Pages: [1]   Go Up
Print
Jump to: