And/Or Logic

jeffgman

I am having trouble with some and/or logic. I am using PHP to connect to a MSSQL server. I have the following in a select statement:

where TT.fkBranchid=@BranchID
and TT.DateCreated >= '{$begdate}' and TT.DateCreated < '{$enddate}'
and (Left(d.instorecode,3)='502' or d.id='312')
and (P.code not in ('089998', '089997'))

In the third line of the where statement, I have that "or" section. I want all of the logic to run, except for the "Left(d.instore,3)='502'" and the "d.id='312'" logic. It does not seem to work the way I have it coded right now. Would somebody be able to tell me what I am doing wrong? And, what the preferred method would be?

Thanks for any help you can offer me.

Jeff

Weedpacket

jeffgman wrote:
I want all of the logic to run, except for the "Left(d.instore,3)='502'" and the "d.id='312'" logic.

I think you're going to have to explain yourself better. The obvious answer at the moment is "don't have it in the query then", but that's probably not what you mean.

jeffgman

Yup, I did not explain myself very well. What I meant to say is that I always want the following logic to be applied:
where tt.fkbranchid = @branchid
and TT.DateCreated >= '{$begdate}' and TT.DateCreated < '{$enddate}'
and (P.code not in ('089998', '089997'))

but, I only want either one of these two logic statements to apply to the row it is accessing:
Left(d.instorecode,3)='502' or d.id='312'

My apologizes for not explaining myself very well originally.

Piranha

Then it should work like this:

where tt.fkbranchid = @branchid
     and TT.DateCreated >= '{$begdate}' 
     and TT.DateCreated < '{$enddate}'
     and (P.code not in ('089998', '089997'))
     AND (Left(d.instorecode,3)='502' or d.id='312')

That seems to be exactly what you started with. Does the query work if you use only one of the where-statements? Start with "where tt.fkbranchid = @branchid" and if that works go to the next row. The last row should be divided into 3, one for each statement ("Left(d.instorecode,3)='502'" and "d.id='312'") and one for both of them. This way you will get to know exactly what it is that is a problem.

Another way to see problems is to echo the query, then it is often possible to spot problems you get with all the PHP logic and variables already submitted.

It could be the @branchid, I just guess that it should be $branchid instead. But I don't know for sure.