title: PHP,MYSQL while loop only displays the last record
body: <p>my code is -    
  
  <pre><code>$dbhost = 'localhost';    
  $dbuser = 'root';    
  $dbpass = '';  
  $dbname = 'moviefone';    
  $con = mysql_connect($dbhost, $dbuser, $dbpass);  
  mysql_select_db($dbname, $con);    
  
  // Check connection    
  if (mysqli_connect_errno()) {  
      echo "Failed to connect to MySQL: " . mysqli_connect_error();    
  }    
  
  $data = mysql_query("SELECT * FROM new_hindi") or die(mysql_error());
  $info=NULL;
  while ($row = mysql_fetch_array($data)){
      $info=$row;
  }
  
  ?&gt;
  </code></pre>
  
  <p>my problem is that the loop only displays the last record from "new_hindi" table.</p>