MySQL INNER JOIN UPDATE SET in php -

select * `surveys` inner join `surveyusers` on `surveyusers`.`survid` = `surveys`.`survid` `surveyusers`.`haswon` = 0 order rand(); update surveys set winner = email; 

i want pick random winner , set winner col in surveys table email in surveyusers table. have lot of trouble it.

updates can take same syntax select.

you can combine these 2 queries one.

update `surveys` `s` set `s`.`winner` = (     select email `surveyusers`     `surveyusers`.`haswon` = 0     , `survid` = 1     order rand()     limit 1 ) `survid` = 1; 

the survid have set php of course.