Jump to content

Archived

This topic is now archived and is closed to further replies.

mcmuney

AND/OR Function

Recommended Posts

I need to make the where statement below and make it where the reverse is also possible, can someone help with rewriting the statement. It basically needs to be WHERE x=1 AND y=2 OR x=2 AND y=1 (it should look for either of these possibilities):

[code]
$query="select * from `sc_friend` where (scf_mem_id={$R}) and (scf_frnd_id={$social_mem_id})";
[/code]

Share this post


Link to post
Share on other sites
where (((scf_mem_id={$R}) and (scf_frnd_id={$social_mem_id}) OR ((scf_mem_id={$R}) and (scf_frnd_id={$social_mem_id} ))

The section before and after teh OR are the same cause i dont understand what you are doing but that will work when you get the right stuff after the or

Share this post


Link to post
Share on other sites
Something like this should work...

[code=php:0]$query="SELECT * FROM `sc_friend` WHERE (x = 1 AND y = 2) OR (x = 2 AND y= 1)";
[/code]

Regards
Huggie

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.