[derfelix]

Well i tried to implement this..(yes i know how to get the number of users)

but the problem persists...

i think the problem lies else where..
i have to randomize the usernumbers and NOT the number of users

maybe my example was not clear enough:

- I have 5 users in db..users 1,2,5,12,11 and 13
actually i have to get the number of resultrows...
which are resultrows 1 to 5

- then i randomize the numbers 1 to 5 reslut: 3
it is not usernumber 3 i want to get (he doesn't exist by the way) but the third resultrow.

that is problem number 1

now to problem number 2:

supposed i solved that, if i randomize everytime i click a random profile, i can get if i do it 5 times:
rows: 1,3,3,4,1 which i dont want..
i want to be able to get:
1,5,3,4,2 for example... and the next time i do it 3,4,2,5,1 (for example)
i'm not so much interested in the exact code (i should be able to find it) but rather in the way to do it...
the code above

$radnomuser = $DB_site->query("SELECT *, userid*0+rand() as randomizer FROM user order by randomizer LIMIT 1");

works fine to give me ONE random profile.. (even in php3)
but it with 5 users for example it gives me at least 2 users twice in 5 goes... (which is normal when you randomly draw 5 objects out of bag)
any ideas?????
plz!!!