query based on 2 conditions

[jeff5656]

I want to select if the doc_type is either s OR f but this doesn't work:

 

$query2 = "SELECT * FROM members WHERE doc_type='s' && doc_type= 'f' ORDER BY username";

 

Also If I want to do two sorts can I do this:

	$query2 = "SELECT * FROM members WHERE doc_type='s' && doc_type= 'f' ORDER BY doc_type, username";

Thanks!

[jcombs_31]

You use literals in MYSQL, even so your logic would currently be wrong because you are using AND.

 

SELECT * FROM table WHERE something = 'something' OR 'something_else = 'something_else'

[lemmin]

I know that logical operators work in other databases like Oracle.

 

You are using a logical AND operator. Use OR (or ||):

"SELECT * FROM members WHERE doc_type='s' OR doc_type= 'f' ORDER BY username";

 

Yes, you can sort twice like that. It sorts by the first, then the second, etc.

[lmhart]

Try

$query2 = "select * from members where doc_type='s' or doc_type='f' order by username

[mrMarcus]

OR...

 

"SELECT * FROM members WHERE doc_type IN ('s', 'f') ORDER BY username";