Warren Vail wrote: > I did not know that about Windows Letter formatting, well, not all Americans > think everything revolves around the way Americans do things. Knowing a > little about Microsoft marketing strategy, they probably feel they should > charge extra for providing more flexible formatting. > > I do believe a good site designer, will plan for a global market, instead of > a local US one, even if others fail to share his vision. quite, quite, I was just jesting :-) > > Warren > >> -----Original Message----- >> From: Jochem Maas [mailto:jochem@xxxxxxxxxxxxx] >> Sent: Friday, November 30, 2007 1:57 PM >> To: Warren Vail >> Cc: 'afan pasalic'; 'Daevid Vincent'; 'php-general' >> Subject: Re: including parenthesis, space and dashes in a phone >> number >> >> Warren Vail wrote: >>> Not to mention that syntax works in the US, but not large portions of >> the >>> rest of the world. (even with the 1 country code in front). >> can't remember when that ever stopped an american. >> >> e.g. Windows print subsystem that shoves 'Letter' format down >> your throat as the default even though the OS knows damn well I'm >> using a european locale. >> >>> Warren vail >>> >>>> -----Original Message----- >>>> From: afan pasalic [mailto:afan@xxxxxxxx] >>>> Sent: Friday, November 30, 2007 12:03 PM >>>> To: Daevid Vincent >>>> Cc: 'php-general' >>>> Subject: Re: including parenthesis, space and dashes in a phone >>>> number >>>> >>>> It's ok to store it this way, but it could be a little PITA when >> search. >>>> E.g., you store (123) 456-7890 and somebody search for 123-456-7890? >>>> Right? >>>> >>>> -afan >>>> >>>> >>>> >>>> Daevid Vincent wrote: >>>>> The kind of opposite of this, is what I use, in that it ADDs the () >> and >>>> - >>>>> if ((strlen($phone)) <= 14) $phone = >>>>> preg_replace("/[^0-9]*([0-9]{3})[^0-9]*([0-9]{3})[^0-9]*([0- >> 9]{4}).*/", >>>>> "(\\1) \\2-\\3", $phone); >>>>> >>>>>> -----Original Message----- >>>>>> From: afan pasalic [mailto:afan@xxxxxxxx] >>>>>> Sent: Friday, November 30, 2007 5:45 AM >>>>>> To: php-general >>>>>> Subject: excluding parenthesis, space and dashes from >>>>>> phone number >>>>>> >>>>>> hi, >>>>>> I store phone number in mysql as integer, e.g. (123) 456-7890 >>>>>> is stored >>>>>> as 1234567890. >>>>>> though, in search form they usually type in a phone number with >>>>>> parenthesis/space/dashes. I have to extract numbers before I search >>>>>> through mysql. >>>>>> >>>>>> currently, I use eregi_replace() function, several times, to >>>>>> do the job: >>>>>> eregi_replace(' ', '', $phone); >>>>>> eregi_replace('(', '', $phone); >>>>>> eregi_replace(')', '', $phone); >>>>>> eregi_replace('-', '', $phone); >>>>>> and it works fine. >>>>>> >>>>>> but, is there any better way? more "fancy"? :) >>>>>> >>>>>> thanks for any help. >>>>>> >>>>>> -afan >>>>>> >>>>>> -- >>>>>> PHP General Mailing List (http://www.php.net/) >>>>>> To unsubscribe, visit: http://www.php.net/unsub.php >>>>>> >>>>>> >>>> -- >>>> PHP General Mailing List (http://www.php.net/) >>>> To unsubscribe, visit: http://www.php.net/unsub.php >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php