Is there a max of AND conjuntions you can use?
where 1='value' AND 2='value' AND 3='value' AND 4='value'
I can only get a max of 3 and actually return a value. Anything above 3 I get zero..... The values are correct... just dont know what to do here.
There is no reasonable max. The problem is your logic, How can a value be both 1 AND 2? I think you want the OR operation.
You might also look at the IN operator WHERE value IN(1,2,3,4) Might do what you want.
my values are not 1,2,3 etc....
Here let me do this better. I have 3 values in the sql that get variables from the url.
Where field1='$variable1' AND field2 ='$variable2' AND field3='asqlvalue' AND field4='$variable3'
Fair enough. I have seen queries with a number of AND's in them so you are not reaching a limit. Are you checking for syntax errors (using something like mysql_error())? You might want to echo out the actual sql statement and post it here.
you know what, IN did the trick man. THX ALOT !, this has been driving me nuts.
