title: MySQL LOAD_FILE returning NULL
body: <p>I'm doing this <code>SELECT LOAD_FILE("/home/user/domains/example.com/public_html/robots.txt") AS tmp FROM tmpTable</code> but it returns NULL. How can I check if this is because I haven't got the FILE privilege or if it's something else? MySQL won't give an error. (I'm using PHP)</p>
  
  <p>Anyone that has experience with LOAD_FILE, tell me about that function:) </p>
  
  <pre><code>&lt;?php
  $result = mysql_query('SELECT LOAD_FILE("/home/user/domains/example.com/public_html/robots.txt") AS tmp FROM tmpTable') or die(mysql_error());
  while($row = mysql_fetch_assoc($result))
  {
  var_dump( $row['tmp'] );
  }
  </code></pre>