<?php
//--Class College--------------------------

include_once "clsbase_College.php";

class College extends base_College{

function RSCollegeByCollegeName($xKey){
    $this->SetQuery("select * from College where collegeName='$xKey'");
}

function RSCollegeByLikeCollegeNameOrderKey($xKey, $orderByKey){
    $this->SetQuery("select * from College where collegeName like '%$xKey%'".$orderByKey);
}

function RSCollegeByLikeCollegeNameOrderKeyLimit($xKey, $orderByKey, $start, $pageSize){
    $this->SetQuery("select * from College where collegeName like '%$xKey%'".$orderByKey." limit $start, $pageSize");
}

function RSCollegeByCollegeNameAndNotCollegeCode($xKey, $yKey){
    $this->SetQuery("select * from College where collegeName='$xKey' and collegeCode!='$yKey'");
}

function RSCollegeLimit($start, $pageSize){
    $this->SetQuery("select * from College order by collegeCode limit $start, $pageSize");
}

} //--End class College--
?>