Location: PHPKode > projects > ConPortal > conportal/inc/seniority_levels/db.php
<?
/*
 *  ConPortal - Pomona College ITS/ Bucknell University ISR scheduling appplication
 *  Copyright (C) 2005-2008  Pomona College & Bucknell University
 *
 *  This program is free software; you can redistribute it and/or modify
 *  it under the terms of version 2 of the GNU General Public License
 *  as published by the Free Software Foundation.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
 */


function getSeniorityString ($seniorityPid)
{
	$result = safeQuery("select description from seniority_levels where pid = '%s'",
		$seniorityPid);
    	$row = mysql_fetch_assoc($result);
  	return $row['description'];
}

function getSeniorityLevels()
{
	$result = safeQuery("select pid, description from seniority_levels");
   	$array = array();
  	while ($row = mysql_fetch_assoc($result))
   	{
   	    $array[] = $row;
  	}
    	return $array;
}
Return current item: ConPortal