AND and an OR in mysql Query

[casbboy]

I have the following Query



mysql_query("SELECT * FROM headline WHERE field=9 OR field=8 AND issue=$issue ORDER BY newsid DESC LIMIT $min,$max",$connection);



The query still grabs rows even if the issue does not equal the $issue variable. How can I fix this?

Thanks
Ryan

[Pig]

mysql_query("
SELECT
*
FROM
headline
WHERE
issue=$issue AND
(
field=9 OR
field=8
)
ORDER BY
newsid DESC
LIMIT
$min,
$max
",$connection);

[casbboy]

Thanks, will give it a try.

Ryan