login

[RON_ron]

this is my login php. But for some reason it dosen't log the user on the first attempt. Any idea what may be causing this?

 

$result=mysql_query("SELECT * FROM  companies WHERE username = '$user' AND password ='$pass'");
if(mysql_num_rows ($result) == 0) {
$login = "&err=Failed.";
echo($login);
} else {
$row = mysql_fetch_array($result);
$user=$row['user'];
$pass=$row['pass'];
$login = "$user=" . $user . "$pass=" . $pass . "&err=Successful.";
echo($login);
}

[ManiacDan]

Ummm...what is it supposed to do?  How do you "log in" a user?  So far this code will print "err=Successful." (which is confusing) if the undefined variables $user and $pass exist in the table.

 

-Dan

[RON_ron]

I'm using this as a server side script. The "err=Successful." will trigger the action. But the issue is why doesn't it allow the user to go through the first attempt. Always the LOGIN button needs to be clicked twice. I wonder if this that's got to do something with this piece of code?

[shlumph]

That looks ok to me, your problem is probably elsewhere.

[RON_ron]

Thanks guys!!