PHP MYSQL 显示打开状态 [英] PHP MYSQL display Open Status

问题描述

我需要修改此脚本以仅显示打开记录.字段称为 statusRP

I need to amend this script to only show Open records. Field is called statusRP

$result = mysql_query("select id, ref, company, title, forename,
                              surname, tel, fax, mob, statusRP, email 
                       from Client");

  if (!$result) {
      die("Query to show fields from table failed");
  }

   $fields_num = mysql_num_fields($result) ;

推荐答案

据我了解，

$result = mysql_query("select id, ref, company, title, forename, surname, tel, fax, mob, statusRP, email from Client WHERE Client.statusRP = 'Open'";) 

还有一件事，使用 mysqli 而不是 mysql(如果 mysql 不是您的要求).我认为它会起作用.

One more thing, Use mysqli rather then mysql (if mysql is not your requirement). I think it will be work.

这篇关于PHP MYSQL 显示打开状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！