Example #1
0
    public static function LoadArrayByMinimumId($intId, $strOrderBy = null, $strLimit = null, $objExpansionMap = null)
    {
        // Call to ArrayQueryHelper to Get Database Object and Get SQL Clauses
        Project::ArrayQueryHelper($strOrderBy, $strLimit, $strLimitPrefix, $strLimitSuffix, $strExpandSelect, $strExpandFrom, $objExpansionMap, $objDatabase);
        // Escape the Parameter(s)
        $intId = $objDatabase->SqlVariable($intId);
        // Setup the SQL Query
        $strQuery = sprintf('
				SELECT
				%s
					project.*
					%s
				FROM
					`project` AS `project`
					%s
				WHERE
					project.id > %s
				%s
				%s', $strLimitPrefix, $strExpandSelect, $strExpandFrom, $intId, $strOrderBy, $strLimitSuffix);
        // Perform the Query and Instantiate the Result
        $objDbResult = $objDatabase->Query($strQuery);
        return Project::InstantiateDbResult($objDbResult);
    }