How to turn off shuffling of SQL query results

Asked Aug 11 '16 at 05:21

Active Aug 11 '16 at 06:42

Viewed 169 times

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

$cat = explode(",",$categories);
Array ( [0] => item1 [1] => item2 [2] => item3 [3] => item4 );

now if I refresh the page the array elements get shuffled

Array ( [0] => item4 [1] => item2 [2] => item3 [3] => item1 );

my mysql fetching 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";

I didnt use any code for shuffling but this comes automatically, how to turn it off?

 foreach ($data as $key => $value){

     $lists = array();                            
     $lists = explode(",",$value['categories']);
 }

edited Aug 11 '16 at 06:42

asked Aug 11 '16 at 05:21

Ranjith M

1

Is $list always the same? How is it generated? – Julian Kuchlbauer Aug 11 '16 at 05:22
1

it won't shuffle if $list is not changing – Ahmad ghoneim Aug 11 '16 at 05:22
$list comes from table i'm fetching it using GROUP_CONCAT and left join@JulianKuchlbauer – Ranjith M Aug 11 '16 at 05:33
thats why the order of items chnaging in `$list` thats why resultant `array` gets `shuffle` – Passionate Coder Aug 11 '16 at 05:34
echo $list for few times to check whether the values changing or not after each refresh. – Mittul Chauhan Aug 11 '16 at 05:34
Can you please provide more code? How do you obtain `$list`? If it comes from the db and you have it separate, why concat? Please add more details to highlight the problem. – Charlotte Dunois Aug 11 '16 at 05:58
you are right $list is changing @Ahmadghoneim – Ranjith M Aug 11 '16 at 06:09
@Ranjith You need to tell how $list is generated – coder Aug 11 '16 at 06:15
`$lists = array(); $lists = ...` is pointless. The second assignment will overwrite the results of the first. – melpomene Aug 11 '16 at 06:24
What's `c` in your SQL? – melpomene Aug 11 '16 at 06:25
$lists = array(); delete that – Ahmad ghoneim Aug 11 '16 at 06:31
This might be a mysql problem, try sorting the `group_concat` part. See: http://stackoverflow.com/questions/995373/mysql-sort-group-concat-values – Yoshi Aug 11 '16 at 06:50
Thanks bro That Worked @Yoshi – Ranjith M Aug 11 '16 at 07:35
Thanks all for commenting@all – Ranjith M Aug 11 '16 at 07:35

How to turn off shuffling of SQL query results

0 Answers0