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). 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