function get_session_number() { # Generate the next session number for specimen registration $today = date("Ymd"); $query_string = "SELECT * FROM specimen_session " . "WHERE session_num='{$today}'"; $record = query_associative_one($query_string); if ($record == null) { $returnValue = $today . "-1"; update_session_number(date("Ymd")); } else { $returnValue = $today . "-" . ($record['count'] + 1); update_session_number(date("Ymd")); } return $returnValue; }
<?php # # Main page for updating counts for specimen session numbers # Called via Ajax from new_specimen.php # include "../includes/db_lib.php"; $session_date_string = $_REQUEST['snum']; update_session_number($session_date_string);