Ejemplo n.º 1
0
 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;
 }