Custom Fields

[Fr3DBr]

Hi, how are the custom product fields stored in the database ? In which way we can fetch their values for a specific customer product ?

[Fr3DBr]

I think, this may be the correct way right:

 

SELECT * FROM tblhostingconfigoptions AS tco INNER JOIN tblproductconfigoptions AS tpco ON tco.configid = tpco.id INNER JOIN tblproductconfigoptionssub AS tpcos ON tco.optionid = tpcos.id WHERE relid = SERVICE_ID

 

- - - Updated - - -

 

While a final version might be:

 

SELECT tpco.optionname as name, tpcos.optionname as value FROM tblhostingconfigoptions AS tco INNER JOIN tblproductconfigoptions AS tpco ON tco.configid = tpco.id INNER JOIN tblproductconfigoptionssub AS tpcos ON tco.optionid = tpcos.id WHERE relid = SERVICE_ID