Thanks for your reply
Heres what Ive got, I've checked it against the working version of the code it just is not building the pages into the menu?
mysql_select_db($database_PowerCMSConnection, $PowerCMSConnection);
$query_AboutRS = "SELECT c2.ContentGroup, c2.ContentPageSetOrder FROM pcms2_contents AS c1 LEFT OUTER JOIN pcms2_contents AS c2 ON c2.ContentPagesetParentID = c1.ContentID WHERE c1.ContentGroup = 'About' AND c2.ContentPageSetOrder IS NOT NULL GROUP BY c2.ContentPageSetOrder Order BY c2.ContentPageSetOrder ASC";
$AboutRS = mysql_query($query_AboutRS, $PowerCMSConnection) or die(mysql_error());
$row_AboutRS = mysql_fetch_assoc($AboutRS);
$totalRows_AboutRS = mysql_num_rows($AboutRS);
}
<li class="parent"><a href="<?php echo($assumedRoot); ?>about.php">About</a>
<ul class="level-1">
<?php do { ?>
<li><a href="<?php echo($assumedRoot); ?>about/allabout.php?About=<?php echo $row_AboutRS['ContentPageSetOrder']; ?>"><?php echo $row_AboutRS['ContentGroup']; ?></a></li>
<?php } while ($row_AboutRS = mysql_fetch_assoc($AboutRS)); ?>
</ul>
<?php
mysql_free_result($AboutRS);
?>