title: inner join mysql tables
body: <p>Ok here it is. i have two tables: products and product_sizes</p>
  
  <p>so basically my product table has id(primary key),name(product name)and size_id(foreign key from product_sizes)</p>
  
  <p>my product_sizes table has predetermined values:</p>
  
  <pre><code>size_id      name
  ------------------
  1            1x1
  2            2x2
  3            3x3
  </code></pre>
  
  <p>and here i have a working code displaying the product tables(in html using while code):</p>
  
  <pre><code>id      name         size_id
  -----------------------------
  1      product 1         1
  2      product 2         2
  3      product 3         1
  </code></pre>
  
  <p>my problem is that i want to display(in html) the size name rather than its size_id, something similar to these example:</p>
  
  <pre><code>id      name         size_id
  -----------------------------
  1      product 1        1x1
  2      product 2        2x2
  3      product 3        1x1
  </code></pre>
  
  <p>can someone teach me how to do this?.. i need it urgently for my final project. thank you. sorry for my explanation im not good in english.</p>