Hi, I have an update and delete admin page for a business directory. When I click on the business id it sends me to the correct business to update/delete, which works fine. But, if the business has the symbol & in it's name it doesn't work, I get sent to the first record in the database. For example, a business named Gary & Sons or Mikes Take Away & Convenience Store.

I would imagine the & symbol means something in SQL so it is confusing itself. If this is correct, is there something I can add to the SQL to make it ignore the & symbol or something like that?

Thanks in advance <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Adam 2e

I'm not sure if I understood you correctly. What type of table field is 'ID'? ID should allways be number so there are no '&' symbols in it.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi, I have an update and delete admin page for a business directory. When I click on the business id it sends me to the correct business to update/delete, which works fine. But, if the business has the symbol & in it's name it doesn't work, I get sent to the first record in the database. For example, a business named Gary & Sons or Mikes Take Away & Convenience Store.

I would imagine the & symbol means something in SQL so it is confusing itself. If this is correct, is there something I can add to the SQL to make it ignore the & symbol or something like that?

Thanks in advance <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Adam 2e


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

Sorry, I have the go to detail page SB set for the business name, so I really am not clicking on the id, just the name of the business. Sorry for the misunderstanding.

Looking forward to your response,

Adam 2e