title: Select * wont print anything in php mysql
body: <p>i made a php script as below ran it and ouput is Record Added to Table</p>
  
  <pre><code>&lt;?PHP
  
  $user_name = "root";
  $password = "";
  $database = "test_db";
  $server = "127.0.0.1";
  $db_handle = mysql_connect($server, $user_name, $password);
  $db_found = mysql_select_db($database, $db_handle);
  
  if ($db_found) {
  
  $SQL = "INSERT INTO name (FirstName) VALUES ('bill')";
  $result = mysql_query($SQL);
  
  mysql_close($db_handle);
  
  print "Records added to the database";
  }
  else {
  print "Database NOT Found ";
  mysql_close($db_handle);
  }
  
  ?&gt;
  </code></pre>
  
  <p>now to see the content of the table i did</p>
  
  <pre><code>&lt;?PHP
  
  $user_name = "root";
  $password = "";
  $database = "test_db";
  $server = "127.0.0.1";
  $db_handle = mysql_connect($server, $user_name, $password);
  $db_found = mysql_select_db($database, $db_handle);
  
  if ($db_found) {
  
  $SQL = "Select * from name";
  $result = mysql_query($SQL);
  
  print "$result";
  mysql_close($db_handle);
  
  print "Records added to the database";
  }
  else {
  print "Database NOT Found ";
  mysql_close($db_handle);
  }
  
  ?&gt;
  </code></pre>
  
  <p>But the output is Resource id #3Records added to the database, while i want to see the contents of the table</p>