mysql_fetch_array() expects parameter 1 to be resource, boolean

[gelobelmonte]

Good day phpfreaks people! i'm a newbie in web programming and I encountered this problem.. I don't know how to fix it.. please help me.. this error prompts everytime i try logging in.. The registration for works but the login doesn't.. please help me.. this is my code where the error is..

 

$db = mysql_connect($mysql_server, $mysql_username, $mysql_password);

  mysql_select_db($mysql_database, $db);

  $sql = "SELECT password, fullname, active FROM ".$mysql_table." WHERE username = '".$_POST['username']."'";

  $result = mysql_query($sql, $db);

  if ($data = mysql_fetch_array($result))

  {

      if ($crypt_pass == $data['password'] && $data['active'] != 0)

      {

        $found = true;

        $fullname = $data['fullname'];

      }

  }

  mysql_close($db);

  if($found == false)

  {

      header('Location: '.$error_page);

      exit;

  }

  else

  {

      session_start();

      $_SESSION['username'] = $_POST['username'];

      $_SESSION['fullname'] = $fullname;

      $rememberme = isset($_POST['rememberme']) ? true : false;

      if ($rememberme)

      {

        setcookie('username', $_POST['username'], time() + 3600*24*30);

        setcookie('password', $_POST['password'], time() + 3600*24*30);

      }

      header('Location: '.$success_page);

      exit;

  }

}

 

Thanks in advance for your help..

 

Gelo

[Pikachu2000]

Your query execution is failing and returning a boolean FALSE. Echo mysql_error, along with the query string to see what the error is and what might have caused it.

[gelobelmonte]

Thanks for your fast response sir.. But what is supposed to be my right code? I'm just a newbie on this that's why I don't have any idea.. Thank you sir!

[trq]

You need to read Pikachu2000's reply again. It's better you learn how to find and fix errors rather than have someone simply do it for you.

[gelobelmonte]

can you explain it to me simpler then? I really don't understand that much..

[Pikachu2000]

Did you read the PHP manual entry for mysql_error() I linked to in my previous post?

[gelobelmonte]

Yes, I have read it.. But I really don't know how to use it.

[Pikachu2000]

The examples are quite clear, which part has you stuck? Post the code you tried to use it in and the errors/problems you encountered.

[gelobelmonte]

The examples are quite clear, which part has you stuck? Post the code you tried to use it in and the errors/problems you encountered.

 

I am not sure on how to use it.. but i tried it this way.. this is where the error occurs

 

$db = mysql_connect($mysql_server, $mysql_username, $mysql_password);

  mysql_select_db($mysql_database, $db);

  $sql = "SELECT password, fullname, active FROM ".$mysql_table." WHERE username = '".$_POST['username']."'";

  $result = mysql_query($sql, $db);

  if ($data = mysql_fetch_array($result))

  {

      if ($crypt_pass == $data['password'] && $data['active'] != 0)

      {

        $found = true;

        $fullname = $data['fullname'];

      }

      else die(mysql_error());

  }

  mysql_close($db);

  if($found == false)

  {

      header('Location: '.$error_page);

      exit;

  }

 

 

[gelobelmonte]

Additional info:

 

i tried adding this:

 

  $result = mysql_query($sql, $db) or trigger_error ( mysql_error ( ) );

 

but a notice prompted at the error message as follows:

 

Unknown column 'active' in 'field list' in /home/mcssonli/public_html/login.php on line 18

 

 

[Pikachu2000]

Well then, there you have it. There is apparently no field named `active` in your table.

[gelobelmonte]

Well then, there you have it. There is apparently no field named `active` in your table.

 

Wow, I think I'm a bit closer.. I need to make a field on the table named as 'active' then? What would be the suggested parameters? Thank you!

[Pikachu2000]

I haven't the slightest idea. I don't know what the rest of the application does. Where did this code come from?

[gelobelmonte]

this is from the login form of our website. www.mcssonline.org. the registration seem to work fine..