mysql字段怎么判断php_php如何判断数据库字段内容

select * from table group by grouptime having count(grouptime) > 1

这样可以查出数据库中grouptime重复数大于1的数据

php代码

$muysqli = new mysqli($host,$user,$pwd,$dbname);

$sql = "select * from table group by grouptime having count(grouptime) > 1";

$res = $mysqli->query($sql);

if(count($res) > 1){//grouptime数量大于1

//do something

}else{//grouptime不大于1

//do something

}

==============================================================

在第二段代码前面加上if判断

if(count($this->otherTitle) > 1){

?>

相关百科

<?php foreach ($this->otherTitle as $key => $v): ?>

<?php echo $v['xtitle']; ?>

endforeach

?>

}else{

echo "【没有百科】";

}

?>