PHP:如果记录存在，则显示HTML，否则不显示任何内容 [英] PHP: If record exists display HTML, else display nothing

问题描述

我是PHP的新手，正在尝试建立一个小型客户数据库.

I'm new to PHP and I'm trying to build a small customer database.

在我的数据库中，我有一列名为"suspended_state"，并且值可以是"yes"或"no"，如果是，我希望它显示Suspended，如果不是，我希望它显示活动".

In my database, I have a column named "suspended_state" and the value can be either 'yes' or 'no' and if it's yes, I'd like it to show Suspended, if it's no I'd like it to display Active.

这是我的代码:

<?php

$result = mysqli_query($con,"SELECT suspend_state FROM tbl_company WHERE company_id='$company_id'");

while($row = mysqli_fetch_array($result));
if ($row['yes'])
echo "Suspended";
else {
echo "Active";
}

?>

但是，无论天气是是"还是否"，所有结果都将恢复为有效"

However, all results come back as Active regardless of weather the column is 'yes' or 'no'

请有人指出我要去哪里了吗?

Please could someone point out where I'm going wrong?

推荐答案

您没有选择名为'yes'的列，而是删除了；如Fred所述，并如BigScar所述添加大括号试试

You aren't selecting a column named 'yes'... and remove the ; as mentioned by Fred and add curly brackets as mentioned by BigScar try

while($row = mysqli_fetch_array($result)) {
  if ($row['suspend_state'] == "yes") {
    echo "Suspended";
  } else {
    echo "Active";
  }
}

这篇关于PHP:如果记录存在，则显示HTML，否则不显示任何内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！