title: MySql Get scrambled results
body: <p>Current scenario :</p>
  
  <p>I have a MySQL database (products_db) with product links ('links') .
  Now the products / links are from 11 different websites (advertisers).</p>
  
  <p>Is there some sort of MySQL query I can make to get the results in groups of 11 links, one link for each website ?</p>
  
  <p>The point is to get a list of results with all the links, one link for each 11 website .</p>
  
  <p>I know I can use the following to get the first 11 rows each from a different website, but I need ALL the results arranged like that .</p>
  
  <pre><code>SELECT id, name, advertiser, link
  FROM table
  GROUP BY advertiser
  </code></pre>
  
  <p>If not, I guess I have to go back to sort the list in PHP ..</p>
  
  <p>thanks!</p>