This is somewhat simplistic. The reason I implemented a simple MAX() query is to move towards centralizing all of my custom SQL into stored procedures.

<?php
--
-- Transaction Maximum Batch Number Stored Procedure
--

USE `cics_app`;

DROP PROCEDURE IF EXISTS Transaction_MaxBatchNumber;

DELIMITER |
CREATE PROCEDURE Transaction_MaxBatchNumber ()
BEGIN
    DECLARE batch_number INT;

    SELECT
        MAX(`transaction`.`batch_number`) INTO batch_number
    FROM
        `transaction`;

    SELECT batch_number;
END;
|
DELIMITER ;
?>

‹ Transaction Count Batch Stored ProcedureupTransaction Open Batches Stored Procedure ›