using $_GET to pass a variable put variable has a &

I am trying to pass a varible through a URL using $GET

WHERE office_name = '$_GET[office_name]'

However, the variable may contain &

For example the office_name variable could be

Jack & Jill

How can I pass the variable without it messing up the query?

Therre shouldnt be a problem since the ampersand isnt special in SQL.

Keep in mind that the variable

Jack & Jill is passed through the URL

Originally posted by sgtpepper
Keep in mind that the variable

Jack & Jill is passed through the URL

Well, you appeared more concerned with the query than the query string.

Use [man]rawurlencode/man or [man]urlencode/man, of course.