splitting a value from the database

[jazztie]

I have telephone numbers stored in a database.
it looks like this i.e. '715144336'
The first two numbers are the area-code ('71') the last seven in the normal number.

However on the edit.php page I want to split this number into a textfield for area-code and a textfield for normal number.
How can I split this value into say $tel_area ('71') and $tel_norm ('5144336')?

Any help will be appreciated!

[Theiggsta]

you can use the ever-so-handy (tm) left() function in your query

SELECT LEFT(715144336,2) FROM tablename (etcetcetc)

that will return '71'

and for the rest of it...

SELECT RIGHT(715144336,7) FROM tablename (etcetcetc)

that will return '5144336'

thats how to do it easily in mysql

[petesmc]

Hi,

You could try:

$tel = ereg("([0-9]{3})(.)", $tel, $tel_n)
$tel_area = $tel_n[1];
$tel_norm = $tel_n[2];


I'm just learning regular expressions really, but it may work. What it does it search the $tel for 3 digits, then another set of any character s of any length. then the first brackets may it the 1 value of the $tel_n array and then the second is the second part.

To print the number out you could either:

print $tel_n[0];

[freddydoesphp]

Unless I am missing something here it would be easiest to use substr() for this, if it is always the case that the frst two numbers are the areacode.

$str_phone = '715551212';
$area_code = substr($str_phone, 0, 2);
$phone_num = substr($str_phone, 2, strlen($str_phone)); 

[petesmc]

That'd work freddy...