title: PHP select one data from mysql NOT DISPLAYING
body: <p>I am trying to display or return the Date value from a selected user</p>
  
  <pre><code>function mysql_select_one_data($database, $table, $data, $country, $phone){  
  $conn = mysql_connect("localhost", "root", "test123");
  
      mysql_select_db($database, $conn) or die (mysql_error());
      $query = "SELECT DATE FROM Temp_Users WHERE Country = '+94' AND Phone = '1234539543';";
  
      $result = mysql_query($query) or die (mysql_error());
  
      if (mysql_num_rows($result) &gt; 0) {
          // output data of each row
          while($row = mysql_fetch_assoc($result)) {
              echo "Date: " . $row["Date"]. "&lt;br&gt;";
          }
      } else {
          echo "0 results";
      }
  
      return $result;
      }
  </code></pre>
  
  <p>result: </p>
  
  <pre><code>Date:
  Resource id #5
  </code></pre>
  
  <p>but when I do the query in phpmyadmin it returns </p>
  
  <p><img src="https://i.stack.imgur.com/iyroY.png" alt="enter image description here">
  <img src="https://i.stack.imgur.com/hCSfz.png" alt="enter image description here"></p>
  
  <p>I am new in Php and I Don't know what I am doing wrong, Thanks for your help. </p>