ampersand error

[Anon]

Hi,

If trying to do a query to the MySQL database via php with & in the string but I'm getting errors back. How can I solve this?

For example: in the MySQL database the keyword is b&b but when it's searches for that string it brings back the errors.

Thanks

Stuart

[Anon]

try using AND or ,

[Anon]

Thanks Mike,

Is there any where of keeping the & symbol in the keyword that is in the database rather than changing them to and.

For example: Rock & Roll, Bed & Breakfast, etc.

Thanks again

[Anon]

Use urlencode function...