error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\login\check_login.php on line 8
Username and Password Incorrect!
codefile : check_loging.php
<?
session_start();
mysql_connect("localhost","root","root");
mysql_select_db("mydatabase");
$strSQL = "SELECT * FROM member WHERE Username = '".trim($_POST['txtUsername'])."'
and Password = '".trim($_POST['txtPassword'])."'";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if(!$objResult)
{
echo "Username and Password Incorrect!";
}
else
{
$_SESSION["UserID"] = $objResult["UserID"];
$_SESSION["Status"] = $objResult["Status"];
$strSQL = "SELECT * FROM member WHERE Username = '".trim($_POST['txtUsername'])."'
and Password = '".trim($_POST['txtPassword'])."'"; <<<<<ตรง'".trim($_POST['txtPassword'])."'" สังเกตดีๆๆๆๆๆ มันมี ""