21 lines
513 B
PHP
Executable File
21 lines
513 B
PHP
Executable File
<?php
|
|
#require_once("config.inc.php");
|
|
|
|
|
|
function get_restplatz($tm_id){
|
|
|
|
$db = dbconnect();
|
|
$query_ges_platz = $db->query("SELECT tm_plaetze FROM bpm_termine WHERE tm_id=$tm_id");
|
|
$row_ges_platz = $query_ges_platz->fetch_array();
|
|
|
|
$query_verf_platz = $db->query("SELECT count(*) Anz FROM bpm_term_kand WHERE tm_id=$tm_id");
|
|
$row_verf_platz = $query_verf_platz->fetch_array();
|
|
|
|
$restplatz = $row_ges_platz['tm_plaetze'] - $row_verf_platz['Anz'];
|
|
return $restplatz;
|
|
}
|
|
|
|
#echo get_restplatz(12);
|
|
|
|
?>
|