Hi, I've been able to manipulate an accessed xml file every way I've needed to, except to get a grouping on the xpath results. I'm looking for a way to query xpath and then have a way to "group by" the results similar to the sql query below ... I'm working in php btw.
SELECT * FROM table WHERE location = '$location' AND day >= '$todaydate' GROUP BY day
Is there an xpath query function or token that can provide a "group by"?
The xml file is provided to me, so I don't have access to preform xls on the original xml.
xpath query group by
in XML
Posted
Hi, I've been able to manipulate an accessed xml file every way I've needed to, except to get a grouping on the xpath results. I'm looking for a way to query xpath and then have a way to "group by" the results similar to the sql query below ... I'm working in php btw.
SELECT * FROM table WHERE location = '$location' AND day >= '$todaydate' GROUP BY day
Is there an xpath query function or token that can provide a "group by"?
The xml file is provided to me, so I don't have access to preform xls on the original xml.
Thanks for your help.