Code: Select all
SELECT
SUM(amount) AS amountR,
COUNT(amount) AS salesR
FROM signups
WHERE affiliateID = '$affiliateID' AND userID IN (SELECT
userID
FROM users
WHERE signupdate = CURDATE())Thanks!