Renegade Public Forums
C&C: Renegade --> Dying since 2003™, resurrected in 2024!
Home » Technical Support » Other » PHP issue
Re: PHP issue [message #441029 is a reply to message #438943] Tue, 07 December 2010 11:56 Go to previous messageGo to previous message
danpaul88 is currently offline  danpaul88
Messages: 5795
Registered: June 2004
Location: England
Karma:
General (5 Stars)
Ah, yes, your MySQL query has faulty logic.

You had;

Condition1 AND Condition2 OR Condition3

Which will always be true if Condition3 is true.


What you probably wanted was

Condition1 AND (Condition2 OR Condition3)

Which would be true if Condition1 was true and ONE of Condition2 or Condition3 were true.


http://steamsignature.com/card/1/76561197975867233.png
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: GameSpy
Next Topic: Generals... AGAIN
Goto Forum:
  


Current Time: Fri Nov 22 20:01:26 MST 2024

Total time taken to generate the page: 0.01081 seconds