MySQL Select Problem

[kumschick]

why does the select shows me even the rows with status set to disable? how make it work without removing

where version='1.1.2' or version_need='1.1.2' or version_need='1.1.1'

select * from mrm_updates where version='1.1.2' or version_need='1.1.2' or version_need='1.1.1' and status='enable' ;
+----+---------+---------+--------------+------------------------------+
| id | status  | version | version_need | link1                        |
+----+---------+---------+--------------+------------------------------+
|  9 | enable  | 1.1.2   | 1.1.1        | /downloads/mrmadmin_v112.exe |
| 13 | disable | 1.1.3   | 1.1.2        | /downloads/mrmadmin_v113.exe |
+----+---------+---------+--------------+------------------------------+

[Roger_Ramjet]

select * from mrm_updates where status='enable' and (version='1.1.2' or version_need='1.1.2' or version_need='1.1.1')

[georgeb]

change:

select * from mrm_updates where version='1.1.2' or version_need='1.1.2' or version_need='1.1.1' and status='enable' ;

to:

select id, status, link1 from mrm_updates where status='enable' and (version='1.1.2' or version_need='1.1.2' or version_need='1.1.1')