<?php function replace(){ $sql = db_query("SELECT field_languages_value,nid FROM {content_type_company_profile} WHERE
field_languages_value like '%Mandarin Chinese%'"); while($result = db_fetch_object($sql)){ $a = explode("Mandarin Chinese",$result->field_languages_used_value); $b = $a[].'Chinese'.$a[1]; db_query("UPDATE content_type_company_profile SET field_languages_used_value = '%s' WHERE nid = %
d",$b,$result->nid); } } ?>
补充:Php教程,Php与数据库
上一个:sql安全之SQL注入漏洞拖库原理解析下一个:简单的php操作mysql数据库实现