Hi

just wanted to know the solution for this problem. this has been bugging me for days!!

not really sure if this is a php thing or mysql thing and sorry in advance if i posted this in the wrong channel.

well here it goes...

say i have 2 mysql queries

$query_1 = "SELECT * FROM `table` ORDER BY RAND()";

$query_2 = "SELECT * FROM `table` ORDER BY RAND()";

when i fetch the result of $query_1 and $query_2, some of matches with the other. what i need is to make all of the returned values of $query_1 different from the returned values of $query_2.

for example

$query_1 returns

2,5,4,3,7

$query_2 should return

1,6,10,8,9

thanks guys~ more power!