\n"; include './---database credentials---'; include './dbconnect.php'; $query="SELECT * FROM ---page table--- WHERE tier = 'code'"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $url=mysql_result($result,$i,"url"); $pagetitle=mysql_result($result,$i,"pagetitle"); $tier=mysql_result($result,$i,"tier"); if ($pagetitle == $pagename) echo '
  • ' . $pagetitle . '
  • ' . "\n"; else echo '
  • ' . $pagetitle . '
  • ' . "\n"; $i++; } include './dbclose.php'; echo "\n \n\n"; ?>