字符串替换的方法

代码

<?php
function replace(){
    $sql = db_query("SELECT field_languages_value,nid FROM {content_type_company_profile} WHERE 

field_languages_value like &#39;%Mandarin Chinese%&#39;");
    while($result = db_fetch_object($sql)){
        $a = explode("Mandarin Chinese",$result->field_languages_used_value);
        $b = $a[].&#39;Chinese&#39;.$a[1];
        db_query("UPDATE content_type_company_profile SET field_languages_used_value = &#39;%s&#39; WHERE nid = %

d",$b,$result->nid);
        }
}
?>