title: PHP MySQL How to fetch xml value
body: <p>I am trying to fetch an XML value from a database, but do not know where to even begin. Basically, I have some XML in a mysql field type of text, and the value I am trying to fetch is "Rachels" as shown here:</p>
  
  <pre><code>&lt;void property="name"&gt;
     &lt;string&gt;Rachels&lt;/string&gt;
  &lt;/void&gt;
  </code></pre>
  
  <p>I am using mysqli procedural, so would like the code in that format.</p>
  
  <p>My code so far looks like this. This code fetches the whole field, not just that one value I want it to fetch.</p>
  
  <pre><code>$blob_query = mysqli_query($dbh8, "SELECT * FROM objstore WHERE obj_id='$characterId' AND type='PLAYER' AND namespace_int='3' ORDER BY obj_id DESC LIMIT 1");
          if($blob_query){
              $blob_row = mysqli_fetch_assoc($blob_query);
              echo $blob_row['data'];
          }
  </code></pre>
  
  <p>So I need to extract the value from that XML. Thanks for the help in advance!</p>