|
|
|
| | 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 '';
//echo 'A-'.$g['Image'];
if ($g['Image'] != "")
{
if ($g['Image'] != 'staff/AAC/dsc_0242.jpg'){
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 '
|
|
';
if ($s['Name'])
{
echo '';
}
if ($s['Title'])
{
echo '';
}
if ($s['Position'])
{
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);
echo '';
} */
if ($s['Email'])
{
echo '';
}
if ($s['Phone'])
{
echo '';
}
if ($s['Education'])
{
echo '';
}
echo '| Name: | '.$s['Name'].' | | Title: | '.$s['Title'].' | | Position: | '.$s['Position'].' | | Position: | '.$scat['Name'].' | | 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);
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: | '.$scat['Name'].' | | Email: | '.$s['Email'].' | | Phone: | '.$s['Phone'].' | | Education: | '.$s['Education'].' | | Bio: | '.$s['Bio'].' | | |
|
';
}
?>
|
query('SELECT * from Staff_Cat where Site="1" 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="1" order by Sort');
while ($ss = $connector->fetchArray($staffs))
{
echo '';
}
}
?>
|
|
!['.$s['Name'].'](/uploads/'.$s['Image'].')
