Log In Code :: doesn't work

seaminem

	function LonInFx($LName,$LPass)

{
	$sql = "select * from member where username = '$LName'";
	$res = mysql_query($sql) or die ("Cannont select from member database");

	$MyStatus = False;

	if (mysql_errno() == 0) // no error
	{
		if (($MyStatus) && (mysql_num_rows($res) == 1))

		$Temp = mysql_fetch_row($res);

		if (($Temp[2] == ($LPass))

		{
			$ErrMsg = "Password is incorrect.<BR>";
		}

		else
		{
			$Status = $Temp[1];
		}
	}
	else //error
	{
		print mysql_error();
	}

	return $Status;
}

This is a login fucntion. This function will receive values from the maing log-in form; $Lname and $Lpass. It will return $Status to the main from. $Status is a username. So the main form will print $Status ... EX. Welcome, username.

bodzan

if (($Temp[2] == ($LPass)) //<-- After if you have two { and later on you haven't closed one of them

Just a guess... 🙂

seaminem

still error

Warning: Failed opening 'LogInFunction.php' for inclusion (include_path='.;c:\php4\pear') in C:\FoxServ\www\FinalProject\index.php on line 5

bpat1434

That's a paths problem....

But in looking at your code, I see some logical flaws:

$MyStatus = False;

    if (mysql_errno() == 0) // no error
    {
        if (($MyStatus) && (mysql_num_rows($res) == 1))

You never reset $MyStatus, so thus $MyStatus will always be FALSE and your second if() statement won't fire (which I think is getting the row into a temp variable).

if (($Temp[2] == ($LPass))

        {
            $ErrMsg = "Password is incorrect.<BR>";
        }

If the database password ($Tempt[2]) is equivalent to the supplied pass ($LPass), wouldn't that mean the password is correct?

if (($Temp[2] == ($LPass))

THis has a parse error in it:
3 opening "(", 2 closing..... (but you mentioned you fixed it)

Your current issue is with the path to the included file. Without seeing just what paths you're using, and what code you're using to include them, we can't help you

seaminem

thank you