这里需要寻找到 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);