title: Select specific column from specific row using old mysql_* API
body: <p>I've got a table in my SQL Database, and the table has two fields, one for an id, and the other for an integer. I want to grab the value in the integer field where the id is equal to a specific number I pass in. The id field is called &quot;id&quot; and the integer field is called &quot;loglevel&quot;. This is the code I've got, but it doesn't give me the desired result.</p>
  <pre><code>$result = mysql_query(&quot;SELECT loglevel FROM Logs WHERE id='$number'&quot;);
  echo &quot;Pulled from SQL: &quot; . $result;
  </code></pre>
  <p>The output for this is</p>
  <pre><code>Pulled from SQL: Resource id #2
  </code></pre>
  <p>Can you help me so the output is &quot;2&quot; if the value in the SQL table is 2?</p>