代码之家  ›  专栏  ›  技术社区  ›  YasirPoongadan

如何写入whmcs内部连接“where条件”

  •  0
  • YasirPoongadan  · 技术社区  · 12 年前

    whmcs内部连接“where条件”,

    两个表具有相同的字段。

    在where条件下如何区分表名?

    尝试了这个,

    $table = "tblclients";
    $fields = "id,firstname,lastname,domain";
    $where = array(
       "lastname"=>array("sqltype"=>"LIKE","value"=>"Demo"),
       "companyname"=>array("sqltype"=>"NEQ","value"=>""),
    );
    $sort = "id";
    $sortorder = "ASC";
    $limits = "0,5";
    $join = "tblhosting ON tblhosting.userid=tblclients.id";
    $result = select_query($table,$fields,$where,$sort,$sortorder,$limits,$join);
    

    如何在where条件下指定表名?

    1 回复  |  直到 12 年前
        1
  •  1
  •   Loïc    12 年前
    $where = array(
       "table1.lastname"=>array("sqltype"=>"LIKE","value"=>"Demo"),
       "table2.companyname"=>array("sqltype"=>"NEQ","value"=>""),
    );