I'm trying to add a total to the end of a query this is what I came up with please help some one
mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT (*) FROM Machine WHERE ((OS_NAME like '%XP%') AND (OS_NAME like '%W' at line 2] in EXECUTE(
"SELECT GROUP_CONCAT(DISTINCT IF(LABEL.NAME NOT LIKE 'HDN_LABEL_%', LABEL.NAME, NULL) SEPARATOR '\n') AS LABEL_NAME, OS_NAME, USER_LOGGED FROM MACHINE LEFT JOIN MACHINE_LABEL_JT ON (MACHINE_LABEL_JT.MACHINE_ID = MACHINE.ID) LEFT JOIN LABEL ON (LABEL.ID = MACHINE_LABEL_JT.LABEL_ID) WHERE ((OS_NAME like '%XP%') AND (OS_NAME like '%Windows%')) GROUP BY MACHINE.ID ORDER BY LABEL_NAME, OS_NAME, USER_LOGGED,
SELECT COUNT (*) FROM Machine WHERE ((OS_NAME like '%XP%') AND (OS_NAME like '%Windows%')) GROUP BY TOTAL RESULT LIMIT 0")
Answers (0)
Be the first to answer this question
