PHP random items from mysql

[janak]

Hi all,
Could someone please tell me how I can do the following ?

I have a table in mysql called ITEMS, and the table contains 5 items (A, B, C, D, E).

I want to select 3 items at random from the database each time the page is loaded.

After the items have been selected I want to store them in variable:

ie:
var_1 = A
var_2 = C
var_3 = D

is it possible to do the above ?

Thanks
Janak

[HalfaBee]

Try

SELECT * FROM table ORDER BY RAND() LIMIT 3

You should be able to do the rest.

HalfaBee

[janak]

thanks HalfaBee,
its the next stage that i am kinda stuck at, how would I set 3 variables from the data extracted from mysql using your method ?

cheers
Janak