Inserting random numbers into a field col

[Ward]

Hi,

I'm still having trouble with the same problem:

http://www.sitepointforums.com/showt...search+results

Is it possible to insert/update a field col with rand numbers automatically, lets say once a day?

Then I guess I should be able to Order my results by this field and so have a result set that is different every 24 hours.

I've tried to go down the RAND() route but with paging, the results are random on every loop, and if I seed the RAND, the results, though random, are always the same even when the same query is made.

Help please!!

Warren

[jofa]

Order by rand(n), and set n = today's date?

[Ward]

Hi, haven't tried it yet, but will that stop the results re-randomising on each re-iteration of the loop? The biggest problem I have found is just using Rand () the results are different when navigating forward and backward through them.

[Ward]

jofa,

thanks, it works a treat and so simple to.

Warren