title: How to select all even id's from a Table?
body: <p>I want to select all even posts id's from a table in my MySQL db and then display them. I also want to get all posts with odd id's and display them somewhere else.</p>
  
  <p>I want to do this with PHP since that is the server-side language I am using. </p>
  
  <p>Alternatively, would I have to select all posts and then check if they are even/odd with JavaScript? I would prefer PHP, but if it works with JavaScript that would be fine too.</p>
  
  <p>Example of what I want:</p>
  
  <p>table:</p>
  
  <pre><code>==================================================
  id | text
  ==================================================
  ==================================================
  | 1 | Lorem ipsum dolor sit amet, consectetur adipiscing elit. |
  ================================================== 
  | 2 | turpis quis aliquet commodo, urna quam viverra justo, in |
  ==================================================
  | 3 | Etiam in lectus sem. Nullam molestie nisl vel nunc consectetur |
  ==================================================
  | 4 | Vestibulum eu molestie sapien. Ut luctus nulla vel libero sagittis |
  ==================================================
  </code></pre>
  
  <p>my failed attempt at a table in stackoverflow ^^</p>
  
  <p>I want to display the even ones first, and the odd ones second:</p>
  
  <p>Even Rows:</p>
  
  <hr>
  
  <p>turpis quis aliquet commodo, urna quam viverra justo, in</p>
  
  <p>Vestibulum eu molestie sapien. Ut luctus nulla vel libero sagittis </p>
  
  <hr>
  
  <p>Odd Rows: </p>
  
  <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit</p>
  
  <p>Etiam in lectus sem. Nullam molestie nisl vel nunc consectetur</p>