RE: [PHP-DB] Escaping &

Thanks to all for your help. I had to step away for a while yesterday so I am just now getting back to your responses. Here is what I was having a problem with: <a href=\"sales_location.php?Customer="$Customer\" target=bottom_right>$Customer</a> Based on your responses, here is what I have now (this works!): <a href=\"sales_location.php?Customer=" . urlencode($Customer) ."\" target=bottom_right>$Customer</a> As you can see, urlencode did the trick. Thanks again everybody!! Randy Rankin -----Original Message----- From: Ken Sommers [mailto:mrsql.php@worldnet.att.net] Sent: Thursday, July 12, 2001 10:27 PM To: Rankin, Randy; php-db@lists.php.net Subject: Re: [PHP-DB] Escaping & Please explain the dynamic link . is that in the documentation somewhere>? Kne ----- Original Message ----- From: "Rankin, Randy" <randy.rankin@invensys.com> To: <php-db@lists.php.net> Sent: Thursday, July 12, 2001 8:18 AM Subject: [PHP-DB] Escaping & > 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 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net