|
|
|
| | Select a staff member or group from the right |
';
}
if ($HTTP_GET_VARS['CatID'])
{
echo '';
//get the group picture of category
$CatID = $HTTP_GET_VARS['CatID'];
if ( $validator->validateNumber($CatID,'Staff Category ID') )
{
$group = $connector->query('Select * from Staff_Cat where ID="'.$CatID.'" limit 0,1');
$g = $connector->fetchArray($group);
echo '';
if ($g['Image'])
{
echo '';
}
echo '';
}
else
{
echo "Can not display staff section: ".$validator->listErrors();
}
echo '|
!['.$g['Name'].'](/uploads/'.$g['Image'].') | | |
';
}
if ($HTTP_GET_VARS['StaffID'])
{
echo '';
//get the group picture of category
$StaffID = $HTTP_GET_VARS['StaffID'];
if ( $validator->validateNumber($StaffID,'Staff ID') )
{
$staff = $connector->query('Select * from Staff where ID="'.$StaffID.'" limit 0,1');
$s = $connector->fetchArray($staff);
if ($s['Image'])
{
if ($s['Name'])
{
echo '';
}
echo '';
}
else
{
echo '';
}
}
else
{
echo "Can not display staff section: ".$validator->listErrors();
}
echo '|
| |
';
if ($s['Bio'])
{
echo '';
}
echo '
!['.$s['Name'].'](/uploads/'.$s['Image'].')
|
';
if ($s['Name'])
{
echo '';
}
if ($s['Title'])
{
echo '';
}
//if ($s['CatID'])
//{
// //select Category Name
// $staff_cat = $connector->query('Select * from Staff_Cat where ID="'.$s['CatID'].'" limit 0,1');
// $scat = $connector->fetchArray($staff_cat);
if ($s['Position'])
{
echo '';
}
if ($s['Email'])
{
echo '';
}
if ($s['Phone'])
{
echo '';
}
if ($s['Education'])
{
echo '';
}
echo '| Name: | '.$s['Name'].' | | Title: | '.$s['Title'].' | | Position: | '.$s['Position'].' | | Email: | '.$s['Email'].' | | Phone: | '.$s['Phone'].' | | Education: | '.$s['Education'].' | | |
|
Bio: |
| '.$s['Bio'].' |
|
';
if ($s['Name'])
{
echo '';
}
if ($s['Title'])
{
echo '';
}
// if ($s['CatID'])
// {
//select Category Name
// $staff_cat = $connector->query('Select * from Staff_Cat where ID="'.$s['CatID'].'" limit 0,1');
// $scat = $connector->fetchArray($staff_cat);
if ($s['Position'])
{
echo '';
}
if ($s['Email'])
{
echo '';
}
if ($s['Phone'])
{
echo '';
}
if ($s['Education'])
{
echo '';
}
if ($s['Bio'])
{
echo '';
}
echo '| Name: | '.$s['Name'].' | | Title: | '.$s['Title'].' | | Position: | '.$s['Position'].' | | Email: | '.$s['Email'].' | | Phone: | '.$s['Phone'].' | | Education: | '.$s['Education'].' | | Bio: | '.$s['Bio'].' | | |
|
';
}
?>
|
query('SELECT * from Staff_Cat where Site="2" and Active="1" order by Sort, Name');
// Get an array containing the results.
// Loop for each item in that array
?>
|
|
fetchArray($result))
{
echo '';
$staffs = $connector->query('Select * from Staff where CatID="'.$row[ID].'" and Site="2" order by Sort');
while ($ss = $connector->fetchArray($staffs))
{
echo '';
}
}
?>
|
|
