Re: Escaping &
| From: | Andreas Iwanowski | Date: | Thu, 12 Jul 2001 18:52:51 +0000 |
| Subject: | Re: Escaping & | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10358@lists.php.net to get a copy of this message | ||
Do you explode the customer names with X ?
"Randy Rankin" <randy.rankin@invensys.com> schrieb im Newsbeitrag
news:F3BF649E168BD411A1B700010271F38BB4BB36@SBMAIL...
> Hello,
>
> I have a table in a MySQL DB (RH Linux/Apache) with a field called
> customer_name. Some of the customer names have an ampersand in them (ie; X
&
> X Supply). I am performing a select statement on this table to create a
> sales summary with customer name and total sales.
>
> This works fine; however, I am also creating a dynamic link on the
customer
> name so that the user can click on it to get a detailed report of sales to
> that customer. This works great EXCEPT for the customers with ampersands
in
> thier names. The result of clicking on these customers indicates a "No
> Records found for X" where X is the letter immediately preceding the
> ampersand.
>
> Does anyone know how to get around this?
>
> TIA,
>
> Randy Rankin