title: Retrive data from database and display in table using php
body: <p>I have two table named ITEM and Price. These are the fields and data of both table</p>
  
  <pre><code>Table : ITEM    
  item_id | item_name
    1     | ABC
    2     | XYZ,JKL,QWE
  
  Table : Price    
    id    | item_price | item_id
    1     | 50         |  1
    2     | 60         |  2
    3     | 100        |  1
  </code></pre>
  
  <p>Where item_id is reference of ITEM table. I need to create table in php to display all the data from ITEM table. item_name have multiple value seperated with coma. So we need to explode them and use as a drop-down(select) in table.My expected outputt will look like given below.</p>
  
  <pre><code>item_id | item_name | item_price
  </code></pre>
  
  <p>Note : item_name must have select option (dropdown)</p>