[Resolved] mysql query

[richie]

My question is about the two queries below:

$query = "select email from db where login = '$login' && (col='agent' || col='broker') ";

$query = "select email from db where login = '$login' && $col='agent' || $col='broker' ";

Is the parenthesis doing anything in the first query?

What I want is this:

where login = '$login' && $col='agent' ";

OR

where login = '$login' && $col='broker' ";

TIA,
Richie.

[csn]

The first query is the one you want. The second will select when the first two params are true, OR when just the last param is true (since AND has precedence over OR).

[richie]

Thank you for that answer. I just wan't sure if the parenthesis had any significance.