php - php 中没有显示空的 MySQL 查询

Question

我有一个功能:

function getNgoIn_the_field_Jobs($ngo_id){
global $db;
return $db->query('SELECT `in_the_field_jobs`.*, `ngo`.`title` AS `ngo_title`, `ngo`.`money` AS `ngo_money`, `ngo`.`time` AS `ngo_time`, `ngo`.`love` AS `ngo_love`, `ngo`.`rating` AS `ngo_rating`, `ngo`.`logo` AS `ngo_logo` 
                    FROM `in_the_field_jobs` 
                    INNER JOIN `ngo` 
                    ON (`ngo`.`ngo_id` = `in_the_field_jobs`.`ngo_id`)
                    WHERE `in_the_field_jobs`.`ngo_id` = ' . (int)$ngo_id );
}

我的查询是:

<?php $in_the_field_jobs = getNgoIn_the_field_Jobs($ngo_id);

if(!empty($in_the_field_jobs)) { ?>
   <h5>Work in the Field</h5>
<?php } ?>

所以我希望 Work in The Field 仅在返回数据时才显示，但它不起作用...即使返回 0，它也会显示。

Answer 1

FWIW，我发现这更容易阅读 - 但请参阅绑定(bind)查询...

"
SELECT j.*
     , ngo.title ngo_title
     , ngo.money ngo_money
     , ngo.time ngo_time
     , ngo.love ngo_love
     , ngo.rating ngo_rating
     , ngo.logo ngo_logo 
  FROM in_the_field_jobs j
  JOIN ngo 
    ON ngo.ngo_id = j.ngo_id
 WHERE j.ngo_id = $ngo_id;
"