7 Replies Latest reply on Jan 20, 2016 9:24 AM by zacckos

    How to perfom Complex Queries Using The PHP API


      Hello Guys

      Second Question toiday!!!
      I am trying to perform a login query as such it needs to check 2 fields

      such as


      **** PseudoCode****'

      SELECT User Where Uname == 'username' and password == 'Password '


      I have tried doing this using a complex query


      ****Code Snippet******


        $findcommand = $fm->newFindRequest('Contact Details');

        $username = "janedoe@gmail.com";

        $qname = '=="'. $username .'"';

        $findcommand->addFindCriterion("user name", $qname);

        $findcommand->addFindCriterion("password", "pasword2");

        $compoundFind = $fm->newCompoundFindCommand('Contact Details');




      I have tried to accomplish this with a compound request with data that is in the database but I get an error

      Read Error: No records match the request

      I am fairly new to Filemaker and the API I would appreciate any correction or pointing in the correct direction