Question

please help am getting this error "Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\wamp\www\SDPMDashboard\login\home.php on line 7"

Answer 1

The php code is below
<?php
include_once('db.php');
// Grab User submitted information
$SDPM_Name=$_POST["SDPM_Name"];
$Password=$_POST["Password"];
$result=mysql_query("SELECT SDPM_Name,Password FROM sdpmnamesnew WHERE SDPM_Name='$SDPM_Name' AND Password='$Password'");
$row=mysql_fetch_array($result);
if($row["SDPM_Name"]==$SDPM_Name && $row["Password"]==$Password)
{
include"login2.php";
}
else
{
echo"Sorry, your credentials are not valid, Please try again.";
}
?>

Answer 2

Have you tried printing value of $result?
Also try this after executing query
```php
if(!$result) die (mysql_error());
```