title: Multiply 2 table rows to get total
body: <p>I'm trying to multiply 2 table rows but the total price doesn't appear in the table. Here's my code:</p>
  
  <pre><code>$result = mysqli_query($connect,"SELECT * FROM `inventory_item` LIMIT $offset, $total_records_per_page");
  while ($row = mysqli_fetch_array($result))
          {
  
              $item_name = $row ['item_name'];
              $total_price = $row['price'] * $row['quantity'];
              $total_price = $row['total_price'];
              echo '&lt;tr&gt;&lt;td&gt;'.$row['id']. '&lt;/td&gt;&lt;td&gt;'.$row['item_name']. '&lt;/td&gt;&lt;td&gt;'.$row['description']. '&lt;/td&gt;&lt;td&gt;'.$row['unit'].'&lt;/td&gt;
              &lt;td&gt;'.$row['quantity']. '&lt;/td&gt;&lt;td&gt;'.'P'. ''.number_format((float)$row['price'],2,'.',''). '&lt;/td&gt;
              &lt;td&gt;'.$row['total_price'].'&lt;/td&gt;&lt;td&gt;'.$row['assigned_officer']. '&lt;/td&gt;&lt;td&gt;'.$row['claimdate']. '&lt;/td&gt;
              &lt;td&gt;'.$row['status'].'&lt;/td&gt;
              &lt;td&gt;&lt;a href="inventory_statusEditRecordsFinal1.php?CO='.$item_name.'" title="Click to edit records" class="btn btn-primary"/&gt; Edit  &lt;/a&gt;&lt;/td&gt;
              &lt;td&gt;&lt;a href="inventory_deletestatusFinal.php?item_name='.$item_name.'" title="Click to delete records" class="btn btn-primary" onclick="return ConfirmDelete()"/&gt; Delete  &lt;/a&gt;&lt;/td&gt;
  
              &lt;/tr&gt;';
  
  
          }
  </code></pre>