random value inside php foreach loop

[bugcoder]

Hi all,

 

did anyone came across a situation when you have to select random values from table e.g like this

 

array is this (Note: 1 id is twice in below array)

$ids = array(1,2,1,3,4);

 

and when i foreach loop on $ids array and use

 

ORDER BY RAND() ASC limit 1

 

in mysql query from hasandbelongsToMany third table to fetch random data against above $ids array ids, i get the same record for 1

 

where as i want random record.

 

Does random of mysql works in foreach loop in too short time?

 

If not how to overcome this situation?

 

============

might be my question is still not clear to many.

[fenway]

MySQL has no arrays.