Array code.

[nbenton]

Hi I'm kind of new with arrays and I think that's what I need to use to code what I'm trying to do. I logically can figure out what I'm trying to do but I can't quite see the code.

Basically I have a table in a database that has one column is a switch. The field could have a value of 0, 1 or 2. The page displays the info based on the switch Show if 1 . ...

My Querry and Switch is working fine but what I'm try to do is.

Get results where Switch=2 then with the results I want to make it random .

I can also make the random work if it's within the querry pulling from all the records but I only what to do a random querry on the records that have a switch value of 2.

I think what I'm trying to do is fairly basic but I've never done it. If anyone could point me in the right direction it would be most helpful.

TIA

Nikki

[HalfaBee]

It sounds like a simple sql query is needed here.

select * from table where switch=2 order by rand()

Halfabee

[nbenton]

That's great. Your right it's that simple I never even thought to put the rand() in the order. It works great thank you.

Nikki