关于取出关键词并且计算出相关长度

这里需要寻找到 model表里面对于非个人用户的关键字描述 而有事通过评价表来寻找的.

//查找关键字
$sql_model="select keywords from phpcms_model where modelid=".$memberinfo[‘modelid’].”“;
$sql_data=sql_data_array($sql_model);

    //查询总评论数

$sql_records="select count(1) as records,round(avg(level)) as level,round(avg(price)) as money from phpcms_pingjia where userid=".$userid.”“;
$records_data=sql_data_array($sql_records);

    //关键字评分
    $sql_data[0]['keywords']=str_replace('，',',',$sql_data[0]['keywords']);
    $str_key='';
    $key_array=explode(',',$sql_data[0]['keywords']);
    foreach ($key_array as &$kw) {
        $sql_key="select count(1) from phpcms_pingjia where tag like '%".$kw."%' and userid = ".$userid."";
        $key_data=sql_data_array($sql_key);
        $kw=$kw."(".$key_data[0]['count(1)'].")";
        $str_key=$str_key.",".$kw;
        unset($kw);
    }
    $sql_data[0]['keywords']=substr($str_key, 1);