update post_details AS pd, (SELECT AVG(rank) AS rting, COUNT(*) AS nm_votes FROM votes WHERE post_id = $post_id_var_u_phpu) AS v SET rating = v.rting, num_votes = v.nm_votes WHERE pd.post_id = $post_id_var_u_phpu;