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

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

//查找关键字
sqlmodel="selectkeywordsfromphpcmsmodelwheremodelid=".memberinfo[‘modelid’].”“;
sqldata=sqldataarray(sql_model);

    //查询总评论数

sqlrecords="selectcount(1)asrecords,round(avg(level))aslevel,round(avg(price))asmoneyfromphpcmspingjiawhereuserid=".userid.”“;
recordsdata=sqldataarray(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);