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.