Search the Community
Showing results for tags 'php mysqli select sum group'.
Found 1 result
-
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
