Error while searching list in MYSQL

Question

I have a problem in my system of sending emails newsletter, when loading the index, where the list of registered emails is loaded, the following error appears:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean   given in /home/barie742/public_html/admin/admin/index.php on line 284

On line 284 it’s like this:

  <?php
  $sql = mysql_query("SELECT * FROM n_emails order by -id");
  while($lista2 = mysql_fetch_array($sql)){  /* line 284 */
  $email = $lista2["email"];
  $ativo = $lista2["ativo"];

What could be wrong ? And how can I fix ?

I thank all who try to help.

Answer 1

I think you might be using $result inside that while to do something making it fake

         <?php
      $sql = mysql_query("SELECT * FROM n_emails order by -id");
      $resultado = mysql_query($sql) or die(mysql_error());
      while($lista2=mysql_fetch_array($resultado)) {
          $email = $lista2["email"];
          $ativo = $lista2["ativo"];
      }