[PHP-DB] Re: Now, how about Roman Numerals?

[Hugh Bothwell]

"David Shugarts" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Second poser today:
>
> How to use either a MySQL select statement or PHP to produce a roman
> numeral, starting from an arabic (INT) number in a database?


In PHP:


function RomanDigit($dig, $one, $five, $ten) {
    switch($dig) {
        case 0:    return "";
        case 1:    return "$one";
        case 2:    return "$one$one";
        case 3:    return "$one$one$one";
        case 4:    return "$one$five";
        case 5:    return "$five";
        case 6:    return "$five$one";
        case 7:    return "$five$one$one";
        case 8:    return "$five$one$one$one";
        case 9:    return "$one$ten";
    }
}

function IntToRoman($num) {
    if (($num < 1) || ($num > 3999))
        return("No corresponding Roman number!");

    $m = $num / 1000;
    $c = ($num % 1000) / 100;
    $x = ($num % 100) / 10;
    $i = $num % 10;

    return(
         RomanDigit($m, 'M', '', '')
        .RomanDigit($c, 'C', 'D', 'M')
        .RomanDigit($x, 'X', 'L', 'C')
        .RomanDigit($i, 'I', 'V', 'X')
    );
}


--
Hugh Bothwell     [EMAIL PROTECTED]     Kingston ON Canada
v3.1 GCS/E/AT d- s+: a- C+++ L++>+++$ P+ E- W+++$ N++ K? w++ M PS+
PE++ Y+ PGP+ t-- 5++ !X R+ tv b++++ DI+++ D-(++) G+ e(++) h-- r- y+




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php