[SOLVED] Query - if x apperars in other table

[isedeasy]

I have a table called 'products' and another table called 'flags'.

 

If somebody flags a product it adds a row into the flags table which with the products unique 'id' value (as well as others).

 

I have a page in the admin panel which will display products that are flagged, I'm having a problem with the query I need to use to achieve this.

 

Any help would be much appreciated.

[Maq]

Can you show us the table structures?

[isedeasy]

yeah sure (sorry for posting in the wrong forum)

 

products

--id

--user

--status

--title

--image

--description

--link

 

flags

--id

--product

--reason

--description

[akitchin]

this can be fetched using a simple inner join:

 

SELECT f.*, p.*
  FROM flags f
    INNER JOIN products p
    ON f.product=p.id
  ORDER BY f.id

 

here's a pretty good explanation of joins in wikipedia:

 

http://en.wikipedia.org/wiki/Join_(SQL)

 

as always, it's good practise to trim the returned columns from a query to only the columns you intend to use, rather than the whole row.

[isedeasy]

Thanks that works a treat