PhP MYSql Question

[nimzie]

I have a simple query:

 

SELECT DISTINCT Email_Address, Name, Role FROM contest_entry where Contest_ID = 1")

 

i am using this query to populate an HTML Table for display.

 

I also want to have a "pick random" button to go through the same result set and pick/highlight (or some custom action) a winning record.

 

What's my best approach for this?

 

Thanks,

 

Adam

 

[fenway]

Not sure what you mean... you already have the data from the db...