Select query

[dudejma]

This query works, but it doesn't do what I want it to do. I'm guessing I worded it wrong but I don't know how to word it. I have:

 

$sql = "SELECT * FROM users WHERE hub='2' AND status='1' OR status='2' OR status='3' OR status='4' ORDER BY pilotid ASC";

 

But I only want pilots who's hub is 2, not all pilots with statuses 1, 2, 3, and 4. I can't just say select all where hub = hub number because I have pilots with status 0 and that means their not yet activated. I don't want them to show up. Thanks!

[Nodral]

try

$sql = "SELECT * FROM users WHERE hub='2' AND status <> 0 ORDER BY pilotid ASC";

 

[Muddy_Funster]

you could use brackets:

$sql = "SELECT * FROM users WHERE ((hub='2') AND (status='1' OR status='2' OR status='3' OR status='4')) ORDER BY pilotid ASC";

Other (better?) ways to write it could be

$sql = "SELECT * FROM users WHERE hub='2' AND status IN ('1','2','3','4') ORDER BY pilotid ASC";

Or

$sql = "SELECT * FROM users WHERE hub='2' AND status BETWEEN '1' AND '4' ORDER BY pilotid ASC";

[AyKay47]

$sql = "SELECT * FROM users WHERE hub='2' AND status IN ('1','2','3','4') ORDER BY pilotid ASC";

 

would be my preferred method here

[fenway]

Agreed -- the most explicit -- the BETWEEN is an accident.