title: Mysql Select Second Row
body: <p>I have a mysql question.</p>
  
  <hr>
  
  <p>I have a news section on my website, and I want to display the two latest items.
  If I do:</p>
  
  <pre><code>SELECT * FROM nieuws ORDER BY id DESC LIMIT 1
  </code></pre>
  
  <p>it selects the latest item,
  and now I want to select the second to last item.</p>
  
  <p>Do you guys know how to do it?</p>
  
  <p>/// EDIT</p>
  
  <p>Now it doesn't work, here's my code: (I have connect included ;) )</p>
  
  <p>
  
  <pre><code>            $select = mysql_query("SELECT * FROM nieuws ORDER BY id DESC LIMIT 1");
              while($row = mysql_fetch_assoc($select)) {
              $datum = $row['time'];
              $titel = $row['title'];
              $bericht = $row['message'];
              ?&gt;
              &lt;div class="entry"&gt;
  
                  &lt;span class="blue date"&gt;&lt;?php echo "$datum"; ?&gt;&lt;/span&gt;
                  &lt;h3&gt;&lt;?php echo "$titel"; ?&gt;&lt;/h3&gt;
                  &lt;p&gt;&lt;?php echo "$bericht"; ?&gt;&lt;/p&gt; &lt;br /&gt;
              &lt;/div&gt;&lt;!-- end of entry --&gt; &lt;?php } ?&gt;
              &lt;?php 
              $select2 = mysql_query("SELECT * FROM nieuws ORDER BY id DESC LIMI 1, 1");
              while($row2 = mysql_fetch_assoc($select2)) {
                  $datum = $row2['time'];
                  $titel = $row2['title'];
                  $bericht = $row2['message'];
                  ?&gt;
              &lt;div class="entry"&gt;
                  &lt;span class="green date"&gt;&lt;?php echo "$datum"; ?&gt; &lt;/span&gt;
                  &lt;h3&gt;&lt;?php echo "$titel"; ?&gt;&lt;/h3&gt;
                  &lt;p&gt;&lt;?php echo "$bericht"; ?&gt;&lt;/p&gt;
              &lt;/div&gt; &lt;!-- end of entry --&gt; &lt;?php } ?&gt;
          &lt;/div&gt;&lt;!-- end of news --&gt; 
  </code></pre>