Jump to content

xpath query group by


katydid

Recommended Posts

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...