title: How to turn off shuffling of SQL query results
body: <p>I have an array which contains some data, I'm getting that array using explode a string the problem is it's get shuffled on every page refresh, how can I turn off that automatic shuffle</p>
  
  <pre><code>$cat = explode(",",$categories);
  Array ( [0] =&gt; item1 [1] =&gt; item2 [2] =&gt; item3 [3] =&gt; item4 );
  </code></pre>
  
  <p>now if I refresh the page the array elements get shuffled </p>
  
  <pre><code>Array ( [0] =&gt; item4 [1] =&gt; item2 [2] =&gt; item3 [3] =&gt; item1 );
  </code></pre>
  
  <p>my mysql fetching code</p>
  
  <pre><code>    "SELECT *,  GROUP_CONCAT(DISTINCT c.category_name SEPARATOR ',') AS categories , 
              FROM subscription s
              LEFT JOIN subscription_category sc ON s.subscription_id=sc.subscription_id
              LEFT JOIN category c ON sc.category_id=c.category_id
              GROUP BY s.subscription_id
              ORDER BY s.subscription_id DESC";
  </code></pre>
  
  <p>I didnt use any code for shuffling but this comes automatically, how to turn it off?</p>
  
  <pre><code> foreach ($data as $key =&gt; $value){
  
       $lists = array();                            
       $lists = explode(",",$value['categories']);
   }
  </code></pre>