"; echo "
กรุณาทำการ Login ก่อน
execQuery($query); $numrows = $dbObj->_numrows; //echo $numrows; /** Paging */ $display = ( !isset ($_GET['page']) ) ? 1 : $_GET['page']; $start = ( ($display * $limit) - $limit ); /** Paging */ if( isset($_GET['OrderBy']) ) { //$query = " SELECT * FROM $myTable2 WHERE Budget_Year='$Budget_Year' AND StaplanId ='$StaplanId' ORDER BY $OrderBy $ASCDESC "; $query = "select * from projstrategy_tb ps, prostrategymap_tb psm, proplanstrateg_tb pps, project_type_tb pt where psm.Budget_Year = '$Budget_Year' and psm.StratempId = '$StratempId' and psm.StrateId = ps.StrateId and psm.StratempId = pps.StratempId and pps.StaplanId = pt.StaplanId ORDER BY pt.Orderlist $ASCDESC"; } elseif( !isset($_GET['OrderBy']) ) { //$query = " SELECT * FROM $myTable2 WHERE Budget_Year='$Budget_Year' AND StaplanId ='$StaplanId' ORDER BY $myTable2PK ASC "; $query = "select * from projstrategy_tb ps, prostrategymap_tb psm, proplanstrateg_tb pps, project_type_tb pt where psm.Budget_Year = '$Budget_Year' and psm.StratempId = '$StratempId' and psm.StrateId = ps.StrateId and psm.StratempId = pps.StratempId and pps.StaplanId = pt.StaplanId ORDER BY pt.Orderlist $ASC"; } $query .= " LIMIT $start, $limit "; $result = $dbObj->execQuery($query); $query = "select * from projstrategy_tb ps, prostrategymap_tb psm where psm.Budget_Year = '$Budget_Year' and psm.StratempId = '$StratempId' and psm.StrateId = ps.StrateId"; $result2 = mysql_query($query); $RSstrat = mysql_fetch_array($result2); ?> |