removing from email?

[sandbudd]

I have a database where the email address are combined with the user name (this is not my doing) is there a php code that anyone knows that can separate these here is an example and thanks in advance.  All of them have the -- before the actual email address.

 

[email protected]

[rhodesa]

$string = '[email protected]';
list($user,$email) = explode('--',$string);

[gevans]

Do you want to split them just for use??

 

if so you can do this;

 

$foo = '[email][email protected][/email]';
$bar = explode('--',$foo);
echo $bar[0];//username
echo $bar[1];//email

[sandbudd]

will that remove everything except the email address?

[sandbudd]

there are over 2000 emails would I have to do this for each email?

[gevans]

no it will set variables with the email and username seperated

[sandbudd]

thanks but would I have to do this manually with each email? or just query the table row?

[gevans]

just use thats after you've queried the table