Retrieving records with names has ‘&’ character

[salkirwi]

Hi all.
My experience is limited and I would appreciate any help.

I have built a website for our business using Dreamweaver CS4 and php-mysql. Site address:

www.ezbrowse.co.uk

The site has a form to feed local business details into a database. It also has a page that shows a list of all entries with facility to update/delete. The problem I am having is that when I try to call any records from the database for updating or deleting, in some case, it would not show. I have narrowed it down the problem to: any business name has ‘&’ sign (such as ‘Smith & Smith’ ) the request returns empty. It seem the ‘&’ is causing the problem. Any idea how can I overcome this snag.

Thanks

[NogDog]

Use [man]htmlspecialchars/man or [man]htmlentities/man when outputting the string to the browser.

[salkirwi]

Thanks for your kind help.

It gave me a new field to explore and understand.

Cheers