[adammc]

Hi guys,

I'm a little stuck can anyone possibly help?

I have a template (row'header') for an email stored in a MYSQL table. An example of the data in the 'header' column is:

Dear %%NAME%%, 

What I was hoping to achive is to replace "%%NAME%%" with a results from another table:

// Get the contents of the template from the database 
        $query = " SELECT * FROM Gift_Voucher_temps WHERE id=$template";
    $result = mysql_query($query); 
            if (!$result) { echo("ERROR: " . mysql_error() . "\n$result\n");    } 
        while($row=mysql_fetch_array($result))  
    { 


// Get the gift voucher details 
        $query2 = " SELECT * FROM Gift_Vouchers WHERE id=$voucher_id";
    $result2 = mysql_query($query2); 
            if (!$result2) { echo("ERROR: " . mysql_error() . "\n$result2\n");    } 
        while($row2=mysql_fetch_array($result2))  
    { 



$newheader = preg_replace ('%%name%%', $row2['name'], $row['header']); 
echo $header; 

This didnt echo a thing
Am I going about this the right way?

[sutabi]

echo $newheader; 

[adammc]

Im getting the following error:
Warning: preg_replace() [function.preg-replace]: Unknown modifier 'N'

[sarav_dude]

try this:

$newheader = preg_replace ('#^%%NAME%%$#', $row2['name'], $row['header']); 

[adammc]

Hmmm... That got rid of the errror but echoed "Dear %%NAME%%," instead of the name ($row2['name'] in the database ?

[sarav_dude]

OOps try this:

$newheader = preg_replace ('#%%NAME%%#', $row2['name'], $row['header']); 

[adammc]

AWESOME!!!
Thank you so much sarav_dude you have just opened upa whole new world of opportunities to me. This is gonna make my developing work ALOT easier