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:[EMAIL PROTECTED]]
Sent: Saturday, June 30, 2001 12:45 PM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to