"David Shugarts" <Azimuth@CompuServe.com> wrote in message BB0C0EE7.21AF3%Azimuth@CompuServe.com">news:BB0C0EE7.21AF3%Azimuth@CompuServe.com... > 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 hugh_bothwell@hotmail.com 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