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.
$query_2 should return
thanks guys~ more power!