我有以下查询:
UPDATE
users AS t
LEFT JOIN (
SELECT
user
FROM
facebook, users
WHERE
facebook.user = users.id
GROUP BY
users.id
) AS m ON
m.user = t.id
SET
t.coins =t.coins+200
WHERE
m.user = t.id
我需要帮助创建一个php脚本,必须实际发送电子邮件给我更新硬币的数量的用户。email字段在users表中
谢谢!
选择所有需要的行:
SELECT
t.id, t.email
FROM
users AS t
LEFT JOIN (
SELECT
user
FROM
facebook, users
WHERE
facebook.user = users.id
GROUP BY
users.id
) AS m ON
m.user = t.id
WHERE
m.user = t.id
,然后更新PHP循环中的每一行,你也可以发送邮件。
假设$result
是var,结果为数组
foreach($result as $res){
$sql = 'UPDATE users SET coins = coins+200 WHERE id = '.$res['id'];
mail(/*WITH YOUR PARAMS*/); //email in $res['email'];
}