How to avoid a PHP parse error in this mySQL query

[blakekr]

I need to use this mySQL query, but PHP doesn't like the brackets:

$query = "SELECT * from products
where prod_name RLIKE '[[:<:]]$trimmed[[:>:]]'
OR
prod_descrip RLIKE '[[:<:]]$trimmed[[:>:]]'
order by prod_name, prod_descrip";

Obviously, I'm a newbie (the book's in the mail!). Can someone show me how to escape or format this to PHP's liking?

[Roger_Ramjet]

try using mysql_real_escape_string

Read it carefully and pay attention to the bit about magic quotes.