[RESOLVED] random order within category based on day of month

[etoast]

Hello
I want to order my db results randomly between three categories, so everything in category one will always appear above category two, etc.

Here is the code I have, which is working fine:

$query = "SELECT car, model FROM (SELECT * FROM cars ORDER BY RAND()) AS t ORDER BY orderno DESC"; 

where orderno is the field containing the category numbers 1, 2, or 3. However, I have pagination, so I only want the randomness to be changed daily. How can I add a fixed number, like day of the month, to make sure the ordering is only updated once a day?

Many thanks for any suggestions!

[etoast]

OK, found something that works:

$query = "SELECT car, model FROM cars ORDER BY orderno DESC, RAND(" . date("Ymd") . ") DESC"; 

Seems to do what I want.

[vivek151189]

check what query have u given above
above query was

$query = "SELECT car, model FROM (SELECT * FROM cars ORDER BY RAND()) AS t ORDER BY orderno DESC"; 

[vivek151189]

you don't have evn the table name

[etoast]

Sorry? Both the above queries work, and both have a table name. The first one will randomly order each category, but will change the order each time you refresh the page. The second query will only change the order when the computer clock ticks over to a new day.

But thanks for taking the time to look.
Regards

[vivek151189]

etoast;11004560 wrote:

But thanks for taking the time to look.
Regards

mention not
not a need for that