title: SELECT Count php/sql
body: <p>I am trying to store a mysql value into a php variable. I have the following query which I know works. However, I the value for $count is always 0. Can someone explain what I need to do to get the count value? The count should be the count of x's w here name_x=.$id. </p>
  
  <pre><code>$query = "SELECT COUNT(name_x) FROM Status where name_x=.$id.";
  $result = mysql_query($query);
  $count = $result;
  </code></pre>