I want to sort by random

Question

This is my line of code that shown products from database, but I want to show it randomly every time.

Code:

$products = DB::select("SELECT * FROM products ORDER BY category = 75 DESC LIMIT 4");

`category = 75` looks like it should be in a `where` clause. — user3783243, May 27 '18 at 13:02
There are many threads on this topic already, have you looked at them already and they didn't resolve the issue? — user3783243, May 27 '18 at 13:03
Are you wanting to select 4 random products with category 75? — Alessi 42, May 27 '18 at 13:06
Based on your comments I don't think the question has a full description of what you want. Please update, the `category = 75` is misleading, if you really want random categories. — user3783243, May 27 '18 at 13:09

Daniel · Answer 1 · 2018-05-27T13:12:46.767

1

Why you ordering by category = 75? You meant where category = 75?

You can use ORDER BY RAND():

$products = DB::select("SELECT * FROM products ORDER BY RAND() LIMIT 4");

but you may expect some performance issues.

edited May 27 '18 at 13:12

answered May 27 '18 at 13:03

Daniel

Yeah, but i want to show random from a database category. – gucci boss May 27 '18 at 13:04
75 is the category id. – gucci boss May 27 '18 at 13:04
@gucciboss Please define exactly what you want in the question. 4 random and different categories everytime? – user3783243 May 27 '18 at 13:07
So better way is select all categories from db, shuffle them in php and run your query with id from first row of shuffled array. – Daniel May 27 '18 at 13:07
Thank you, i have completed that. – gucci boss May 27 '18 at 13:11

score 1 · Answer 2 · answered May 27 '18 at 13:09

1

Simply use RAND() to order randomly;

$products = DB::select("SELECT * FROM products where category = 75 ORDER BY RAND() LIMIT 4");

answered May 27 '18 at 13:09

lucky

2 Answers2