Jump to content

Where in the database can I find what Users have what Product Configurable Options


Recommended Posts

Hi guys,


Where in the database is the information as to what users have taken which Product Configurable Options? I know there is an API call to get this information, but I am doing a cross database join with another system, so need to go in via MySQL.


Any help at all would be much appreciated.

Link to comment
Share on other sites



SELECT t2.fieldname, t1.value, t3.userid, t3.id AS productid FROM tblcustomfieldsvalues AS t1 LEFT JOIN tblcustomfields AS t2 ON t1.fieldid = t2.id LEFT JOIN tblhosting AS t3 ON t1.relid = t3.id


But since it's not clear to me what are your WHERE conditions, you should explain it more in details.

Link to comment
Share on other sites

Hi Kian,


First of all thank you for your reply. A bit of help is greatly appreciated in this instance.


I am taking in all users on a particular billing cycle. Let say its


tblclients AS clients 
tblhosting AS hosting 
clients.id = hosting.userid 
hosting.billingcycle = "Premium Account"


In the real query a great many more tables are joined, based on "clients.id", but this example should give you an idea of where I am going with this.


I would like to apply a second join to the query above, that indicates which of the Product Configurable Options, this client has opted for. I'd love if that was in a column-by-column format, but I'm not to bothered with formatting so long as the extra information is there.


- - - Updated - - -


By the way. Your example seems to use a different table. I am talking about the ones in "tblproductconfigoptions", and how those apply to clients.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated