That's is wonderfull Hugh.. Nabil "Hugh Bothwell" <hugh_bothwell@hotmail.com> wrote in message 20030611045527.87485.qmail@pb1.pair.com">news:20030611045527.87485.qmail@pb1.pair.com... > "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