PHP MySQLi Select sum and group

[andyd34]

I'm trying to select some things from a few tables, what i want is to work out the payroll of what i have to pay my employees week by week but am failing misserably. I can select the sum but it isnt breaking down into weeks.

 

Here is my code

"SELECT ".PREFIX."tEmployees.IdEmployee,
        ".PREFIX."tEmployees.employeeName,
        ".PREFIX."tPayroll.IdPayroll,
        ".PREFIX."tPayroll.IdInvoice,
        ".PREFIX."tPayroll.IdEmployee,
        SUM(".PREFIX."tPayroll.PayeAmount) AS Wage,
        WEEK(".PREFIX."tPayroll.CreatedDate) AS 'Week',
        YEAR(".PREFIX."tPayroll.CreatedDate) AS 'Year',
        ".PREFIX."tOrderInvoices.InvoiceCurrency,
        ".PREFIX."tOrderInvoices.InvoiceNumber,
        ".PREFIX."tCurrency.CurrencySymbol
        FROM 
        ".PREFIX."tPayroll LEFT JOIN ".PREFIX."tEmployees ON 
        ".PREFIX."tEmployees.IdEmployee = ".PREFIX."tPayroll.IdEmployee 
        LEFT JOIN ".PREFIX."tOrderInvoices ON 
        ".PREFIX."tOrderInvoices.IdInvoice = ".PREFIX."tPayroll.IdInvoice 
        LEFT JOIN ".PREFIX."tCurrency ON 
        ".PREFIX."tCurrency.IdCurrency = ".PREFIX."tOrderInvoices.InvoiceCurrency 
        GROUP BY 
        ".PREFIX."tEmployees.IdEmployee ASC");

Like i say i am getting results but they arnt breaking down into weeks

[requinix]

Well yeah: you're only grouping the data per employee. If you want it broken down by week then you'll need to group by the week too.

[andyd34]

Thanks for that. I know it was something stupid but couldn't see the wood for the trees haha