$q=mysql_query("SELECT * FROM `memb` WHERE `clan` = '$clan[id]' "); while($post=mysql_fetch_assoc($q)){ mysql_query("UPDATE `users` SET `gold` = `gold` + 100 WHERE `id` = '$post[user]'"); }