simple SQL Problem

[Arc]

This SQL statement only returns a row if the first argument in the Or clause is true. If the Second argument is true it returns false.

$Sql="SELECT * FROM tblReg WHERE ((OnlineID='$SESSION_UNAME' Or COnlineID='$SESSION_UNAME') AND FileName='Blah')";
$Result=mysql_query($Sql,$Connect);
$NumRows = mysql_num_rows($Result);
If($NumRows > 0){
 $Reg = TRUE;
}else{
 $Reg = FALSE;
}

If OnlineID = the Session name the $Reg returns true, but if COnlineID = the Session name and OnlineID does not then $Reg returns false. It is supposed to return true if either field = the Session name.

Is there something wrong with that SQL statement that would casue it to return the wrong value?

Thanks!😃

[trooper]

Don't forget you have an AND clause in that sql

So either the OnlineID or the COnlineID must be equal to the session name AND the FileName must be equal to "Blah".

Sounds like the filename clause is the bit is not being met correctly.

Are you 100% sure of your logic?

HTH

GM

Originally posted by Arc
This SQL statement only returns a row if the first argument in the Or clause is true. If the Second argument is true it returns false.

$Sql="SELECT * FROM tblReg WHERE ((OnlineID='$SESSION_UNAME' Or COnlineID='$SESSION_UNAME') AND FileName='Blah')";
$Result=mysql_query($Sql,$Connect);
$NumRows = mysql_num_rows($Result);
If($NumRows > 0){
 $Reg = TRUE;
}else{
 $Reg = FALSE;
}

If OnlineID = the Session name the $Reg returns true, but if COnlineID = the Session name and OnlineID does not then $Reg returns false. It is supposed to return true if either field = the Session name.

Is there something wrong with that SQL statement that would casue it to return the wrong value?

Thanks!😃 [/B]

[Arc]

Yah that was it. Thanks🙂

[trooper]

What was it the last AND clause?

GM