XML simpleDOM sortedXPath - How to select and display parent attribute?

ldchinh

New Member
xml file :\[code\]<?xml version='1.0' encoding='utf-8'?><MyName><EventGroup Name="Japan Shows" ID="341"> <Event Name="Sapporo" ID="40163" StartTime="07/07/12 06:00:00" /> <Event Name="Consadole" ID="5106" StartTime="07/07/12 07:30:00" /> <Event Name="Albirex" ID="4063" StartTime="07/07/12 05:20:00" /> <Event Name="Niigata" ID="1144" StartTime="07/07/12 09:00:00" /></EventGroup><EventGroup Name="USA Shows" ID="342"> <Event Name="Phoenix" ID="40162" StartTime="07/06/12 09:00:00" /> <Event Name="California" ID="5105" StartTime="07/08/12 08:30:00" /> <Event Name="Seattle" ID="4062" StartTime="07/08/12 02:20:00" /> <Event Name="Chicago" ID="1143" StartTime="07/08/12 04:00:00" /></EventGroup></MyName>\[/code\]code :\[code\]<?phpinclude 'SimpleDOM.php';$xml = simpledom_load_file($cache_file);$count = 0;$max = 50;foreach ($xml->sortedXPath("EventGroup/Event", "@StartTime", SORT_ASC) as $EventGroup => $item) {$time = date("d/m - H:i", strtotime($item['StartTime']));$event_name = $item['Name']; if ($count < $max) { echo "$time"; echo "$event_name"; } $count++;}?>\[/code\]Result :\[code\]07/06 - 09:00 Phoenix07/07 - 06:00 Sapporo07/07 - 07:30 Consadole07/08 - 04:00 Chicago\[/code\]etc...which are all correct.But what about to show the approciate EventGroup Name? How i can select and display the parent name attribute to each event result? The result i desire should be like this :\[code\]USA Shows 07/06 - 09:00 PhoenixJapan Shows 07/07 - 06:00 SapporoJapan Shows 07/07 - 07:30 ConsadoleUSA Shows 07/08 - 04:00 Chicago\[/code\]etc...Thanks in advance for any help!
 
Back
Top