title: search 5 product in mysql and echo 4 different rows
body: <p>im Ivica and im new here.</p>
  
  <p>i need form with 5 places for product codes. Every product have 4 rows (name, perex, amount, library_id) in database and i want place solution every products to different places.</p>
  
  <p>Can help? </p>
  
  <p>Sorry for my english.</p>
  
  <p>DB CODE:</p>
  
  <pre><code>&lt;?php
  
  $mysqli = new mysqli('localhost', 'user', 'pass', 'db');
  
  if ($mysqli-&gt;connect_error) {
  die('Nepodařilo se připojit k MySQL serveru (' . $mysqli-&gt;connect_errno . ')    '
          . $mysqli-&gt;connect_error);
  }
  
  $sql = $mysqli-&gt;query("SELECT library_id, amount, name, perex, extId 
  FROM product_item, main_library, product_item_price, product_text 
  WHERE product_item.product_id = main_library.main_id 
  AND product_item.id = product_item_price.item_id 
  AND product_item.product_id = product_text.product_id 
  AND product_item_price.level_id = 1  AND product_item.extId = '$test'");
  
  echo 'Z databaze jsme ziskali ' . $sql-&gt;num_rows . ' radku.';
  echo "&lt;/br&gt;";
  while ($produkt = $sql-&gt;fetch_assoc())
  {
  printf($produkt['name']);
  echo "&lt;/br&gt;";
  printf($produkt['perex']);
  echo "&lt;/br&gt;";
  printf($produkt['amount']);
  echo "&lt;/br&gt;";
  }
  $sql-&gt;free_result();
  
  $mysqli-&gt;close();
  
  ?&gt;
  </code></pre>