Multiple conditions with MySQL string in PHP

[nerdhurd2]

Greetings,

given :

SELECT * FROM leads Where rowid = '$rowid' AND company = '$currentusercompany' OR company = '$currentusercompany2'

Is there OR only comparing the company field variables or is it also including rowid and if rowid doesnt compare it will select it because a company matches?

Example:

rowid=555
$currentusercompany=test1
$currentusercompany2=test2

which database records would be selected?:

rowid company
555 test1
554 test2
553 test1

ONLY the record with rowid 555 should be selected right? sense rowid 555 is a requirement but it can be eighter company...

Sorry for the wierd example, im just not sure how to word it better

 

[sleipnir214]

According to

http://dev.mysql.com/doc/mysql/en/operator-precedence.html,

MySQL's AND operator has precedence over MySQL's OR operator.

So in MySQL:

"a AND b OR c" will be interpreted as "(a AND b) OR c"

So, no, rowid 555 will not be the only record returned. Rowid 554 will also be returned.


Want the best answers? Ask the best questions!

TANSTAAFL!!