title: How to echo ith row and nth column from a mysql database?
body: <p>I need to echo the 4th rows 3rd column  from a mysql Database</p>
  
  <pre><code>    $query = 'SELECT * FROM picture LIMIT 10';
      $result = mysql_query($query);
      $row = mysql_fetch_array($result,MYSQL_NUM );
  </code></pre>
  
  <blockquote>
    <p></p>
  </blockquote>
  
  <ul>
  <li><p>Question 1 > What does the $result contain ? The table form as seen    in MYSQL ?</p></li>
  <li><p>Question 2 > What does the $row contain ? Just the 1st row ?</p></li>
  <li><p>Question 3 > How can i move to the 4th row ? echo $row[4] doesn't
  work!! ? </p></li>
  <li><p>Question 4 > How can i move to the 4th row column 3 ? </p>
  
  <p><code>echo  $row[4][3]</code> doesn't work!! ?</p></li>
  <li><p>Question 5 - If i have to send 2 rows to back to the client side (
  suppose that ajax requested it from php ) </p></li>
  </ul>
  
  <p>would it be php </p>
  
  <pre><code> $query = 'SELECT * FROM picture LIMIT 5';
  $result = mysql_query($query);
  $rec = mysql_fetch_array($result,MYSQL_NUM );
  
  print_r (json_encode($result[0]));
  </code></pre>
  
  <p>And on html side </p>
  
  <pre><code>$.ajax({
        url: "viewnew.php",
        data: {
           current_image: imId,
           direction    : dir
        },
        success: function(ret){
            console.log(ret);
            var arr = eval(ret);
            alert("first: " + arr[0] + ", second: " + arr[1]);
  </code></pre>