title: Can I have an SQL query where I select all from a table where ID = another query?
body: <p>I want to be able to filter posts based on what the designers do, I have each one in a Boolean in the designer table
  i.e Logo: 1, Website: 0
  The ID is a foreign key which is the same in both tables so I want to show posts based on the data I have in the designer table.</p>
  <blockquote>
  <p>$sqldesigner = SELECT designerID FROM designers WHERE logo = 1;</p>
  <p>$sqlall = SELECT * FROM post WHERE designerID = $sqldesigner;</p>
  </blockquote>
  <p>I want to show the posts based on the designer who made the post, in this example the designer makes logos so in the designer table when he signed up he ticked a box saying logo to set the logo Boolean to 1, currently I show all posts on a page but I want to have a button to filter these posts to only show posts made by a designer who makes logos, my first query is to get all the IDs of the designers who make logos then my second one was to get all posts from those designers</p>
  <p>Hopefully I gave enough info here and thanks in advance for the help</p>