public function outputHowTo($i_howtoID) { $objThis_M = new data(); $s_sql = "select\r\n\t\t\t D.howtoName,\r\n\t\t\t C.chapterID, \r\n\t\t\t C.chapterName, \r\n\t\t\t C.displayOrder,\r\n\t\t\t H.headingID,\r\n\t\t\t H.displayOrder,\r\n\t\t\t H.headingName,\r\n\t\t\t T.contentID,\r\n\t\t\t T.contentTitle,\r\n\t\t\t T.displayOrder,\r\n\t\t\t T.howtoContent\r\n\t\t\tfrom cms.dyn_howto_document D\r\n\t\t\tinner join cms.dyn_howto_content T\r\n\t\t\t on D.howtoID = T.howtoID\r\n\t\t\tleft join cms.cfg_howto_headings H\r\n\t\t\t on T.headingID = H.headingID \r\n\t\t\tinner join cms.cfg_howto_chapters C\r\n\t\t\t on T.chapterID = C.chapterID \r\n\t\t\twhere D.howtoID = {$i_howtoID} \r\n\t\t\torder by\r\n\t\t\t C.displayOrder,\r\n\t\t\t H.displayOrder,\r\n\t\t\t T.displayOrder,\r\n\t\t\t T.howtoContent;"; $q_getData = $objThis_M->runSQL($s_sql); $objThis_V = new view(); $s_main = $objThis_V->outputHowTo($q_getData); return $s_main; }