PHP and Mysql Random

[bokz_42]

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!

[bokz_42]

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!

[buldozerce]

I don't think this will be possible without checking the rows.

[felgall]

Since both queries will return all the results just in different orders there will be no entries in one not in the other.

If you want to split the entries into two lists with half randomly selected for each list then retrieve them using one select and then use PHP to add alternate entries to two different arrays.

[r937]

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

i can understand your indecision, but posting the same question in both places was definitely the wrong move

i've merged the two threads with their different replies together

i like felgall's answer, it's not only simple but most efficient as well