Hi,
I have used the dayname function in my MYSQL query, and when I go to results within phprunner the query displays ok. However when I build the project, the day names don't appear in the list page? Anyone have any ideas?
Query:
SELECT
ID ,IFNULL(branch,6) AS branch, calendar.datefield AS DATE, IFNULL(SUM(service_import.hrs_wrked),0) AS total_hours, monthname(calendar.datefield) AS Month, dayname(calendar.datefield) AS 'DOW'
FROM service_import
RIGHT JOIN calendar ON (DATE(service_import.last_worked) = calendar.datefield)
WHERE (calendar.datefield BETWEEN (SELECT MIN(DATE(last_worked)) FROM service_import) AND (SELECT MAX(DATE(last_worked)) FROM service_import)) AND branch=6
GROUP BY DATE
On the list page the DOW field is blank, but the monthname appears as it should.
