On Thu, 12 Jul 2001 10:18:23 -0500, [EMAIL PROTECTED] (Randy Rankin)

>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
>Does anyone know how to get around this?

Would it be practical to link off a unique record_id instead of the noun-name? 

That way you can assure that the data you're passing doesn't have any
URL-unfriendly characters, and you guarantee that the data you're retrieving is
the unique data you're linking from.


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to