<?php
echo drawHeaderRow("Services", 2, "add new organization", "organization_add_edit.php");
?>
<tr>
<th align="left">Service</td>
<th align="right">#</td>
</tr>
<?php
$result = db_query("SELECT s.id, s.name, (SELECT count(*) FROM web_organizations_2_services o2s WHERE o2s.serviceID = s.id) as countservices FROM web_services s ORDER by s.name");
while ($r = db_fetch($result)) {
?>
<tr>
<td><a href="service.php?id=<?php
echo $r["id"];
?>
"><?php
echo $r["name"];
?>
</a></td>
<td align="right"><?php
echo $r["countservices"];
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
echo drawBottom();
?>
</td>
<td><a href="/staff/view.php?id=<?php
echo $r["userID"];
?>
"><?php
echo $r["first"];
?>
<?php
echo $r["last"];
?>
</a></td>
<td><?php
echo $r["title"];
?>
, <?php
echo $r["departmentName"];
?>
</td>
<td align="right"><?php
echo format_date($r["endDate"]);
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
drawBottom();
