title: Fetching Questions - Insert All rows to my table
body: <p>I have a question in fetching, I want to insert data into my table.</p>
  
  <p>If I echo I get all the data, but when inserting I checked in my table and it only shows 1 piece of data per column instead of multiple rows of data. Assuming its all 13 rows, I get only 1.</p>
  
  <p>I have used this method in my other projects with no problem, why is it different now?</p>
  
  <p>The query only displays 2 columns: Child and Catalog, I need them to be inserted into my table.</p>
  
  <pre class="lang-sql prettyprint-override"><code>select CHILD_RLI, CATALOG_ITEM_NAME From myDB; -- example query
  </code></pre>
  
  
  
  <pre><code>while (($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) != false) 
  {
  
  
      $crli                       = $row["CHILD_RLI"];
      $catalog_item_name          = $row["CATALOG_ITEM_NAME"];
      $str_catalog_name           =  mysql_real_escape_string($catalog_name);
  
      $catalogqry = "INSERT into rli_tbl
                                      (crli,catalog_name) 
                                      VALUES 
                                      ('".$crli."','".$str_catalog_name."')";
  
      mysql_query($catalogqry);   
  
  }
  </code></pre>