error when filtering chart by session user id
hi,
i have amended my recordset on my dynamic chart to filter by userid to only show commission for that user, however i get this error:
DynamicWebCharts/Data/commission_dataparser1_user.php?GET=§accesscheck=/commission_user.php?
this is my recordset:
SELECT MonthPaid AS XLABEL, SUM(Amount) AS YVALUE, clients.ClientUserID, users.UserID
FROM monthlycommission JOIN clients on monthlycommission.ClientID = clients.ClientID JOIN users on clients.ClientUserID = users.UserID
WHERE YearPaid= NOW( ) AND clients.ClientUserID = paramUser
GROUP BY MonthPaid
ORDER BY DatePaid
can anyone help?
thanks