EOH; $result = mysql_query("SELECT page_path AS url, page_modified, page_parent_id FROM `pages` WHERE page_menu_display = 'Yes' GROUP BY page_id ORDER BY `page_path` ASC"); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } while($row = mysql_fetch_array($result)) { //echo $row['page_modified'].'|'; //echo $row['info_modified']; $modified_date = date("Y-m-d\T00:00:00+00:00",strtotime($row['page_modified'])); $url = strtolower($row[url]); $newsdate = date("Y-m-d\T00:00+00:00"); $url = "http://www.reds.co.uk/".$url; echo << $url $modified_date daily EOH; if($row['page_parent_id'] == 0) { echo "1.0"; } else { echo "0.6"; } echo ""; } ?>