Product Price in non WHMCS page

[Adamski]

I'm trying to pull prices from WHMCS db to display on a non WHMCS page. That bit I can do! I also want the corresponding config option prices and that is where I am getting stuck.

 

I cant for the life of me work out what the right SELECT statement is. Does anyone know what the relid in tblpricing refers to for configoptions and how I associate the configoptions data with the product data?

 

TIA

 

Adam

[tomdchi]

Try:

 

SELECT tblpricing.*, tblproductconfigoptions.* FROM tblpricing, tblproductconfigoptions WHERE tblpricing.relid = tblproductconfigoptions.id AND tblpricing.type = 'configoptions'

 

To make it more efficient you would define each field you need instead of getting them all.

[Adamski]

Thanks tomdchi - doesn't quite work. I've got there in the end using two lookups. One get the main product price and the second gets all the config options for it and it's working nicely!