title: use php dbo to display data by referencing row and column number
body: <p>in mysql_* you could use the following to display a specific row and column:</p>
  
  <p><code>mysql_result(3,2)</code> </p>
  
  <p>This would show 3rd row, second colum of result set.</p>
  
  <p>I have a php pdo script to display some mysql data:</p>
  
  <pre><code>$sth = $db-&gt;prepare("SELECT name, surname FROM people"); 
  $sth-&gt;execute(); 
  $row = $sth-&gt;fetch(); 
  $name=$row[name];
  $surname=$row[surname];
  </code></pre>
  
  <p>The above would work well if I had a single result for the query. if I have multiple results, how could I fetch the name and suraname for a specific row and column.</p>
  
  <p>So if I wanted row 11, column 0 and row 11, column 1 (name and surname from row 11) what would my syntax be?</p>
  
  <p>Thanks as always for the advice.</p>