This is probably a very simple solution but i cannot get my head around the syntax.
I have my first table:
ratings
id
name
status
I then have another table
sectors
id
ratingid
name
So my basic query is SELECT * FROM ratings but what I need to do is select all records from ratings WHERE I then look at the sectors table WHERE the sectorid is passed from $_GET and only show records where the sectorid matches the $_GET
Does that make sense? Any help very appreciated..
SELECT * FROM sectors INNER JOIN ratings
ON sectors.rating_id = ratings.id
WHERE sectors.id = $_GET['yoursectorid'];
I think this is what you're looking.