Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

Re: [PHP-DB] Escaping & From: leo g. divinagracia iii (ldivinag <email protected>)
Date: 07/12/01

try using the SUBSTR function to check each string for the first char as
a "&". if it does have it, strip and continue the process...

"Rankin, Randy" wrote:
>
> 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?
> 

-- 
Leo G. Divinagracia III
ldivinag <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>