Update from another table

[dr_overload]

I'm trying to update the value of one field (pts_ga1) with the value of a field within another table (correct_score_ga1), but the update isn't working.

Can anyone point out to me where I have gone wrong.

Thanks

$result = mysql_query("UPDATE world_cup_users SET pts_ga1='(SELECT correct_score_ga1 FROM world_cup_scores)' WHERE username ='$username'");

[bradgrafelman]

Try removing the quotes around the subquery? If you put something in quotes, MySQL will think it's a string.