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

Dealing with code in db query
I am dealing with C code and I need to make sure it is encoded some how to ensure its integrity and

update the selected existing records of database
Hi frndz,
I am new to php and get stuck....

Edit.php > Update.php > Updatea

Parse XML
Good day,

I use oempro software and try to parse XMLReturn but it's not working for me, simpl

onclick problem
I have <input type="text" name="message">
<a href=page2.

login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php

for some reason mysql query not working, not inserting, please check it out
This code is not inserting anything into my db, don't know why, the $_SESSION variable does contain

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

GET vs SUBMIT Button to show sections on one index.php page?
Just curious if one of these ways is better (i.e. more efficient) than the other.

I have a

my two tables
table1 : col1 = topicid , col2 = topic

table2 : col1 = sentid, col2 = sentence

Cod