php multiple AND Select Query

Question

Hi There I'm trying to get some data with this SELECT statement and when I just select two items it gives me result but when I place third item it doesn't give any result.

$Query="SELECT * from tableName WHERE status='true' AND gid='".$gid."' AND section='".$cid."'";

Plz any solution.

this one works fine, but when I add third item status='true'. doesn't work.

$Query="SELECT * from tableName WHERE gid='".$gid."' AND section='".$cid."'";

Which one is the third item? Show us the query that doesn't work and the one that does work. — mdnghtblue, Feb 24 '15 at 18:51
doesn't return data. Just wondering it the above Query with double AND condition fine? — fguru, Feb 24 '15 at 18:57
You're query is fine. What data type is contained in the 'status' column? — Jay Blanchard, Feb 24 '15 at 19:03

score 0 · Accepted Answer · edited May 23 '17 at 12:06

First, let me say this: Double-quoted strings can parse your variables, so this line can work, too:

$Query="SELECT * from tableName WHERE gid='$gid' AND SECTION='$cid'";

Try to learn PHP basics about using single ' and double " quotes here: What is the difference between single-quoted and double-quoted strings in PHP?

Related to the database query, is status field is present in your database table? If not, it should NOT be included within the database, or it will return FALSE boolean value. Instead, use IF if you want to be 'selectively' filtering the status of the table.

if('your conditions here'){
  $query = "SELECT * FROM tableName WHERE gid='$gid' AND section='$cid'";
}

score 0 · Answer 2 · answered Feb 24 '15 at 19:01

0

I think your mistake is the status='true'

probable the database control its field with 1 or 0 value.

answered Feb 24 '15 at 19:01

rLinhares

367
1
4
17

if 'status' is an string field, check with 'link' instead of '=' – rLinhares Feb 24 '15 at 19:06

php multiple AND Select Query

2 Answers2