title: How to display Decimal and Date Arrays from MySQL database using php
body: <p>I am having difficulty getting Price and Date to display on the webpage.</p>
  
  <p>Below is a section of the current code that I have. The MYSQLI_ASSOC part displays the correct data but the MYSQLI_NUM section of the code does not display at all. I am having trouble finding information on how to make it work. </p>
  
  <pre><code> &lt;?php
      $query = "SELECT ItemID, Name, Category, Price, Duration, Photo FROM 
      item ORDER by ItemID LIMIT 3";
      $result = $mysqli-&gt;query($query);
  
    if ($result-&gt;num_rows &gt; 0) {
       // output data of each row
       while($row = $result-&gt;fetch_array(MYSQLI_ASSOC)) {
           echo "&lt;br&gt; Row: ". $row["ItemID"]. " - Name: ". $row["Name"]. "&lt;br&gt; " . $row["Category"] .  "&lt;br&gt;" ;
     }
      } else {
        echo "0 results";
    }
  
      if ($result-&gt;num_rows &gt; 0) {
       // output data of each row
       while($row = $result-&gt;fetch_array(MYSQLI_NUM)) {
         echo "&lt;br&gt; Price: ". $row["Price"]. " - Finish Time: ". $row["Duration"]. "&lt;br&gt; ";
     }
      } else {
        echo "0 results";
    }
  ?&gt;
  </code></pre>