query based on 2 conditions

Posted on 16th Feb 2014 07:03 pm by admin

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

Code: [Select]$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:
Code: [Select] $query2 = "SELECT * FROM members WHERE doc_type='s' && doc_type= 'f' ORDER BY doc_type, username";
Thanks!

Your Answer:

Login to answer

Other forums

Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I

Default TimeZone
The server I'm working with is hosted in America so all times inserted into the database are coming

foreach help.
Hello all,

First time I'm attempting to use a foreach statement and was just wondering if my

need help in dynamic select menu in php
hi i have created a dynamic select menu using php. i have a problem in that which is when the user s

cstdatomic (c++0x std::atomic) / g++ 4.4
Hello,

I'm trying to use cstdatomic (std::atomic in the upcoming c++0x standard) in g++

Help with translating C code into assembler code
Hi im doing a project that moves a robot around a maze avoiding walls and need some help with conver

WS-Security PL/SQL Forms
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - P

need help in update query
i create a form for update. there are 8 columns in my mysql table. on my main page all the data is r

PHP login form help (Done Most of It)
Hi i am having a problem, when i try logging in it is always saying "Invalid Login" im not

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba