Results 1 to 4 of 4
Jun 2, 2003, 03:02 #1
- Join Date
- Oct 2001
- Helston, Cornwall, England
- 0 Post(s)
- 0 Thread(s)
Inserting random numbers into a field col
I'm still having trouble with the same problem:
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.