Hi to xperts here,
I do not know how to update with the follwing requirement
$score_update_query = "UPDATE participation_score SET score_last_update = '$date' , score = (IFNULL((SELECT avg(score)*0.8 FROM entity_score WHERE entity_score.contributor_id = contributor.contributor_id) , 4) + IFNULL((select participation_score*2 from participation_score where participation_score.contributor_id = contributor.contributor_id), 1) ) WHERE participation_score.user_id is null ; ";
as it shows error as
ERROR 1093 (HY000): You can't specify target table 'participation_score' for update in FROM clause.
I am stuck here and some help here would be great.. Not getting exactly what needs to be redone..