Thank you for that subtle clarification Jay! I took a look at the code and eventually I noticed the parenthesis for
two or more I suppose "types". It's sort of a pattern I've noticed. For me to learn this stuff lots of working chunks of code that are useful help me learn even things later down the road so seeing the parenthesis (even without knowing
why they were being used) helped me figure this out. Otherwise I'd have to ask you for clarification.
Here is the working code for anyone who may find this useful as an archive...
Code: Select all
SELECTid, id_for_folder, id_from, date_0, date_1, message, subjectFROM`public_private_messages`WHERE(id_for = '".$_SESSION['member']."' OR id_from = '".$_SESSION['member']."')AND(id_for_folder = 'new' OR id_for_folder = 'read')ORDER BY `public_private_messages`.`date_0` DESC