title: Printing when there's only a single record in MySQL / PHP
body: <p>What's the best way to print from MySQL using PHP when you know there's only going to be a single record?</p>
  
  <p>My SQL statement is:</p>
  
  <pre><code>select user from users where user = 'norman';
  </code></pre>
  
  <p>This will return only a single record. So what's the best way to print it? I currently do:</p>
  
  <pre><code>while ($info=mysql_fetch_assoc($data))
  </code></pre>
  
  <p>etc</p>
  
  <p>But that's OK for more than one record. Any better way to do this when there's only one?</p>