1 Reply Latest reply on Feb 25, 2010 11:16 PM by Radhakrishna Bhat

    Php 5/MySql "Like Query" on a String

    Daniel Pride

      Wrote the Following code in Php, refresehed the services and it does not test out, I am trying to do a simple "Like" query on the BusinessName Field

       

       
              $stmt = mysqli_prepare($this->connection, "SELECT * FROM $this->tablename where BusinessName LIKE ?");
              $this->throwExceptionOnError();


              mysqli_bind_param($stmt, 's', $businessName);       
              $this->throwExceptionOnError();
                 
              mysqli_stmt_execute($stmt);
              $this->throwExceptionOnError();
             
              $rows = array();
              ..............etcn same as generated GetAll Statement

       

      Thanks

      Dan