<?php

function max_verse($name)
{
    $query = "SELECT
            t1.name,
            t2.chapter,
            t2.verse,
            Max(t2.verse) as max_verse,
            t2.text
                FROM   bible_books t1
                    JOIN bible_verses t2
                        ON t1.id = t2.book
                WHERE  t1.name = '$name'
                GROUP  BY t2.chapter
                ";
    $res   = mysql_query($query);
    if ($res) {
        while ($data = mysql_fetch_assoc($res)) {
            $max_verse = $data['max_verse'];

            GLOBAL $max_verse;

        }
    }
}
?>