replacing an email in a string

[corporateboy]

Hi I have a variable

$contents

It basicalled says for example

"this item was emailed to person1 (person1's email) by person2 (person2's email) on date"

how can I strip out the emails (which are in brackets in the dbase) and display the $contents variable on the fly (i want to keep the emails in the variables.

It should be simple but I'm having trouble with it!

thanks,
mike

[xDeadxBeatx]

You would have to use a script like this....

<?php

$dbName = "the name of your database";
$dbHost = "usually localhost";
$dbUsername = "the username thats granted db usage";
$dbPassword = "the password for the granted username";

$connect = mysql_connect('$dbHost','$dbUsername','$dbPassword') or die(mysql_error());

mysql_select_db('$dbName',$connect) or die(mysql_error());

$result=mysql_query("SELECT * FROM //name of table//", $connect);

$rowCheck = mysql_num_rows($result);
if($rowCheck > 0){

while($row = mysql_fetch_array($result)){

$email = $row['email'];

echo "$email";
}
}
?>

Something like that. If you need anymore help just ask.