Hi, Ok I’m having a moment and I cant seem to get my head around this.
What I need to do is get the 10 most reviewed products from a db, whilst joing onto the product table to get its name, so effectively 2 tables:
reviews
rev_id
rev_text
rev_parent (contains id of the reviewed product)
products
product_id
product_title
how could I achieve this?