title: PHP / MYSQL Select From Where Column Equals ( Advanced )
body: <p>I'm not sure how to word this in my title so I'll try and explain the best I can here.</p>
  
  <p>I want to create a news page for my website, having around 8 articles per page, which would be one update via SQL. But I wondered if there was a way to select a particular article based on it's theme using PHP later on. What I would have are 2 tables:</p>
  
  <pre><code>Articles:    ID | Article 1 | Article 2 | Article 3 | etc
  Themes:      ID | Theme 1 | Theme 2 | Theme 3 | etc
  </code></pre>
  
  <p>So a basic post would look like:</p>
  
  <pre><code>Articles:     1 | Text for article 1 | Text for article 2 | Text for article 3 | etc
  Articles:     2 | Text for article 1 | Text for article 2 | Text for article 3 | etc
  Themes:       1 | Local | Sport | Business | etc
  Themes:       2 | Business | Sport | Local | etc
  </code></pre>
  
  <p>So here, In <strong>Post 1</strong>, <code>Article 1</code> is a post about the local area and <code>Article 2</code> is about Sport, whereas in <strong>Post 2</strong>, <code>Article 1</code> is about the Business and <code>Article 2</code> is about Sport.</p>
  
  <p>What I would like to do is have a PHP script which can select any article from any column based on it's theme.</p>
  
  <p>So for instance:</p>
  
  <pre><code>SELECT ( CELL ) FROM articles WHERE ( THE CORESPONDING COLUMN IN THEMES ) = 'Business'
  </code></pre>
  
  <p>I'd also like to be able to select multiple rows. (<code>SELECT * FROM articles LIMIT 12</code>).</p>
  
  <p>Can anyone advise or help with this? Thanks.</p>