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:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 10:27 PM
To: Rankin, Randy; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Escaping &
Please explain the dynamic link .
is that in the documentation somewhere>?
Kne
----- Original Message -----
From: "Rankin, Randy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
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]
--
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]
