Problem with CI db query with parentheses/brackets [SOLVED]

[eluser]coldfire82[/eluser]
[quote author="elvicmic" date="1294282097"]I think something like this should work for you:

Code:

$sql = "SELECT id FROM cars WHERE name = '$car_name'";

[/quote]

As I mentioned earlier, query is not the issue.

SELECT id FROM cars WHERE name = 'BMW (series 1)' works OK as standalone.

But, it doesnt work using CI's db->query