Formatting Strings in MySQL

Is there a certain format you always need the string in? Such as 3 digits followed by a space followed by 3 digits followed by a space followed by 3 digits? Will there ALWAYS be 9 numbers? If this is the case, your ereg() to parse the string and then create a new varible using $regs[x]... so, if the above example IS the case, you could use: if (ereg("^([0-9]{3})([0-9]{3})([0-9]{3})$", $initialValue, $regs) { $var = "$regs[1] $regs[2] $regs[3]"; } This may not be the EXACT code, but it's close... Personally, regexps and I battle often and they always seem to win *grumble* But this should give you the idea. Look at: http://www.phpbuilder.com/columns/dario19990616.php3 or http://www.php.net/manual/en/function.ereg.php for more details. The first is a VERY helpful resource for using regs in PHP. Hope this helps some. Jesse Williams System Administrator DowNET VoIP Team Electronic Data Systems -----Original Message----- From: Artur Correia [mailto:artur.correia@netvisao.pt] Sent: Saturday, June 30, 2001 12:45 PM To: php-db@lists.php.net Subject: [PHP-DB] Formatting Strings in MySQL Hey How can I get a string (or number) from mySQL like "123123123" to display "123 123 123"?? Tks I'm kinda rookie Artur -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net