title: fetch specific data from database using php
body: <p>i would like to ask for an idea of how to fetch information from my database without getting everything in it. For example: i have an article that is consisted of 10 paragraphs in my database but i would only want to fetch 200 characters from it (so that i could have sustained information for my  articles preview). Thanks in advance</p>
  
  <p>currently i am using this code to fetch my data but it gives me everything from the database</p>
  
  <pre><code>$result = mysql_query("SELECT * FROM tblArticles Where id='".$_POST['num']."'");
  
      $count=mysql_num_rows($result);
          if($count&gt;0)
              {
      $row = mysql_fetch_array( $result );
                          $id=$row[0];
                          $title=$row[1];
                          $contents=$row[2];
  
              }
  </code></pre>