Jump to content

Select using 2 groups


phpmo

Recommended Posts

I'm having trouble with a select statement.

 

I've got a table where if have a sender and owner field.

 

I then have a deleteowner and deletesender field. THey are 0=NO and 1=YES

 

I want to write a statement that says.

 

select * from table where owner=$idfield and deleteowner = 0 and sender=$idfield and deletesender=0

 

This isn't working. I only want it to pull by owner if deleteowner=0 and likewise for sender. How do I do this without using 2 statements.

Link to comment
https://forums.phpfreaks.com/topic/210286-select-using-2-groups/
Share on other sites

Archived

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

×
×
  • Create New...

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.