title: SugarCRM Querying Database
body: <p>In SugarCRM, using SOAP API, imagining i have lots of accounts populated in the database, and i want to find the account that has <code>'phone_work' = '00352254856987'</code>. How can i make a query to accomplish that? It would be something like this:?</p>
  
  <pre><code>    $query = "phone_work = '${myPhone}'";
  </code></pre>
  
  <p>For what i have tried, it seems the compiler finds an error in the XML document, which means the query is not well executed. What is the best way to do this kind of queries?</p>
  
  <p>I'm using magento and creating a module to connect to sugar, so it is PHP</p>