Total Posts: 58
I’m in the process of writing a module to display a random selection of products based on some criteria.
My question is does anyone have a sql query kicking around to select all the details of particular products
basically i need to be able to display all the information of a standard catalogue page, stuff like product name, link, price etc
also as a bonus if someone knows the table to get join to get the attributes of a product as well that would be a winner, i’m gonna have a search around the tables tonight if i come up with this i will post it here
Thanks in advance